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
Change your First Dimension as below...
=Date#([Target Delivery / Release Date],'MMM-YY')
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
Change your First Dimension as below...
=Date#([Target Delivery / Release Date],'MMM-YY')
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
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