On 2009-08-03 05:27 Ashish P Aghera wrote:
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
Sorry, I had made a blunder: I had forgotten to change the scale of the
X-axis too...
The solution of fresh chart is not good, because then I would have to
specify the charts exact dimensions, colors, etc.
There are still some minor quirks with the charts, and I will send you
the file if I won't be able to solve them.
Thanks,
emf
-----Original Message-----
From: news [mailto:n...@ger.gmane.org] On Behalf Of Eustace
Sent: Monday, August 03, 2009 2:18 PM
To: users@openoffice.org
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
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org