If you want date in X-axis, you must check the 'First column as label'. because date are stored in first column.
Also to avoid any copy paste error. try for fresh chart by selecting data range. I can look into the file if you send it to me in person. Ashish -----Original Message----- From: news [mailto:[email protected]] On Behalf Of Eustace Sent: Monday, August 03, 2009 2:18 PM To: [email protected] Subject: [users] Calc Chart question In sheet 1 column A there are dates starting from the latest, and in column D there are values. Every year in July I add another 365 or 366 rows at the beginning of the sheet and are dated accordingly, from 7/1 to 6/30 the year before. Every chart is Lines only and has in the X-axis the dates of column 1 and a line with the values of column D, and covers an new year. Every July I copy the previous chart and change the data ranges, for example from $Data.$A$366:$A$731;$Data.$D$366:$D$731 to $Data.$A$1:$A$366;$Data.$D$1:$D$366 Last year, as I remember, this worked fine: as I was adding values in the D column, the line appeared and started progressing in the new chart. This year, however, something is wrong. No line appeared as I added values to the July dates. And instead of dates at the X axis there were the numbers representing the dates. I opened again the data ranges, and unchecked "First column as label". Now the dates appeared as expected at the X axis, but still there is no line with the values of the D column. The charts of former years, BTW, had the "First column as label" checked, and they showed OK. What's wrong? emf -- It ain't THAT, babe! - A radical reinterpretation http://www.geocities.com/itaintme_babe/itaintme.html --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] Standard Disclaimer Conditions as per Tatachemicals Ltd Email Security Policy apply
