Skip to Content
0
Former Member
Apr 29, 2009 at 06:57 AM

Formatting Display of Dates on X-Axis

37 Views

Hi,

I have a problem getting my x-axis labels ( a series of dates) to display on my chart. Originally I was using the dates and it looked fine until previewed or exported to an .swf. whereby the values display #value! or NaN. I then tried inserting another column and using the TEXT() to convert the dates to text. I am now gettting a date displayed but it is displaying from 1-Jan and not the dates that i have in my columns. I have also tried using the inbuilt formatting for the text of the category x axis labels without any success. Any help or ideas would be much appreciated

Thanks

Geoff

Edited by: Geoff Schuhmacher on Apr 29, 2009 8:57 AM