Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi,
How do I get my Y-Axis dates in the right order (i.e. Jan-14, Feb-14 ...etc) at the mo they're in Ascending which is not helpful.
Thanks
Graham
 MK_QSL
		
			MK_QSL
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Change your First Dimension as below...
=Date#([Target Delivery / Release Date],'MMM-YY')

 MK_QSL
		
			MK_QSL
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		can you provide your sample file or qvw?
 
					
				
		
Here goes
 
					
				
		
Your release date field has been stored as text and not numeric. In your script, apply this transformation
Alt(Date#([Target Delivery / Release Date],'MMM-YY')) as [Target Delivery / Release Date]
then in your sort by, sort by numeric value ascending
 MK_QSL
		
			MK_QSL
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Change your First Dimension as below...
=Date#([Target Delivery / Release Date],'MMM-YY')

 maxgro
		
			maxgro
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		or in the chart goto tab sort and sort Target Delivery / Release Date by expression ascending
=Date#([Target Delivery / Release Date],'MMM-YY')
 
					
				
		
Thanks for all your responses, they've been a great help.
Coming from a RAD background having used PowerPoint this appears to be a lot more tricky than I first thought.
Rgds
Graham
 MK_QSL
		
			MK_QSL
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Can you close the thread by selecting correct/helpful answer?
 
					
				
		
Its not that its tricky, it just getting your data types right. Once you have them right, these sort of cosmetic changes are quite easy through the intuitive dialog boxes i.e. sort ascending
The only reason this was tricky was because your date field was captured as text. If you don't know yet, a quick tell is when previewing a table, all text values load left indented and numeric, right indented
Cheers,
Byron
 
					
				
		
Hi Manish,
Just a quick question, how did you get the N/A and TBC to the end? and is it possible not to show the N/A column?
Rgds
Graham
