Sorting Y Axis dates

[#1]

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]

Because you have N/A and TBC in your Target Delivery / Release Date field.

You can remove them by ....

=IF([Target Delivery / Release Date] <> 'N/A' and [Target Delivery / Release Date] <> 'TBC' ,

Date#([Target Delivery / Release Date],'MMM-YY'))

[#3]

Thanks very much Manish, much appreciated.

Rgds

Graham