Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-05-2017, 04:20 PM
jalea148 jalea148 is offline my excel 2010 line chart has a secondary axis. Its horizontal date axis is incorrect. Windows 7 64bit my excel 2010 line chart has a secondary axis. Its horizontal date axis is incorrect. Office 2010 64bit
Novice
my excel 2010 line chart has a secondary axis. Its horizontal date axis is incorrect.
 
Join Date: Jun 2014
Posts: 26
jalea148 is on a distinguished road
Default my excel 2010 line chart has a secondary axis. Its horizontal date axis is incorrect.

I'm using Win 10. My Excel 2010 line chart has a secondary axis. Its horizontal date axis is incorrect. Dates should range 1/1/2013 to 12/31/2013:

All 252 dates are M - F, excluding holidays. Dates is the format listed above.


Prior to changing to secondary axis the horizontal axis was correct.
Reply With Quote
  #2  
Old 01-06-2017, 08:38 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline my excel 2010 line chart has a secondary axis. Its horizontal date axis is incorrect. Windows 7 64bit my excel 2010 line chart has a secondary axis. Its horizontal date axis is incorrect. Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,767
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Your dates seem to be numbers starting from 1 to 239
Please post a small sample of your data ( Click Go advanced - Manage attachments)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 01-06-2017, 09:01 AM
jalea148 jalea148 is offline my excel 2010 line chart has a secondary axis. Its horizontal date axis is incorrect. Windows 7 64bit my excel 2010 line chart has a secondary axis. Its horizontal date axis is incorrect. Office 2010 64bit
Novice
my excel 2010 line chart has a secondary axis. Its horizontal date axis is incorrect.
 
Join Date: Jun 2014
Posts: 26
jalea148 is on a distinguished road
Default

Dates in m/d/yyyy format
1/1/2013 ... 12/6/2013 12/9/2013 12/10/2013 12/11/2013 12/12/2013 12/13/2013 12/16/2013 12/17/2013 12/18/2013 12/19/2013 12/20/2013 12/23/2013 12/24/2013 12/26/2013 12/27/2013 12/30/2013 12/31/2013

Last edited by jalea148; 01-06-2017 at 09:03 AM. Reason: clarity
Reply With Quote
  #4  
Old 01-06-2017, 09:04 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline my excel 2010 line chart has a secondary axis. Its horizontal date axis is incorrect. Windows 7 64bit my excel 2010 line chart has a secondary axis. Its horizontal date axis is incorrect. Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,767
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Please post a sample sheet. Formatting is an important thing to see.
Thank you
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Tags
horizontal axis data

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
my excel 2010 line chart has a secondary axis. Its horizontal date axis is incorrect. Select which labels to display on horizontal axis on line chart Jack H Excel 5 01-13-2016 10:05 AM
my excel 2010 line chart has a secondary axis. Its horizontal date axis is incorrect. How to add a NEW varaible to a secondary horizontal axis Boyko Excel 1 03-02-2015 01:09 PM
Secondry Axis overlapping in bar chart dual axis in Powerpoint 2010 sharath_ms PowerPoint 0 07-08-2013 10:06 PM
Secondary Horizontal Axis excel 2013 darksupernova Excel 0 02-27-2013 08:46 AM
Help with secondary axis on chart Beanster Excel 0 01-30-2012 02:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:27 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft