![]()  | 
	
		
			
  | 
	|||||||
  
 | 
	
| 
		 | 
	Thread Tools | Display Modes | 
| 
		 
			 
			#1  
			 
			
			
			
			
		 
		
	 | 
|||
		
		
  | 
|||
| 
		
	
		
		
			
			 
			
			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.  | 
| 
		 
			 
			#2  
			 
			
			
			
			
		 
		
	 | 
||||
		
		
  | 
||||
| 
		
	
		
		
			
			 
			
			Your dates seem to be numbers starting from 1 to 239 
		
		
		
		
Please post a small sample of your data ( Click Go advanced - Manage attachments) 
				__________________ 
		
		
		
		
		
	
	Using O365 v2503 - 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  | 
| 
		 
			 
			#3  
			 
			
			
			
			
		 
		
	 | 
|||
		
		
  | 
|||
| 
		
	
		
		
			
			 
			
			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  | 
| 
		 
			 
			#4  
			 
			
			
			
			
		 
		
	 | 
||||
		
		
  | 
||||
| 
		
	
		
		
			
			 
			
			Please post a sample sheet. Formatting is an important thing to see. 
		
		
		
		
Thank you 
				__________________ 
		
		
		
		
		
	
	Using O365 v2503 - 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  | 
 
 | 
	
	
| Tags | 
| horizontal axis data | 
| 
		 | 
			 
			Similar Threads
		 | 
	||||
| Thread | Thread Starter | Forum | Replies | Last Post | 
		
		  Select which labels to display on horizontal axis on line chart
	 | 
	Jack H | Excel | 5 | 01-13-2016 10:05 AM | 
		
		  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 |