On 2008-08-15 21:29 Brian Barker wrote:
At 17:16 15/08/2008 -0400, Eustace Noname wrote:
Column A contains dates. Column B contains values. I have made a chart
that has the dates on the X-Axis, while the values form a line. Now, I
would like to have on the X-Axis the dates (and the grid lines) appear
every 30 days. However, in Format > Axis > X-Axis > Scale all the top
fields and Automatic checkboxes are grayed out. Also in Format > Grid,
X-Axis Major Grid is also grayed out. Is there any way to control the
interval of the appearing dates?
Yes: you can adjust the x-axis scaling if you choose "XY (Scatter)"
instead of "Line" for the Chart Type. You can still create a line graph
with or without points.
I trust this helps.
Brian Barker
Thanks. With some fiddling around I solved the problem with the line
chart. But I can't make vertical grid lines appear. In Format > Grid >
only the Y Axis Major Grid... is selectable.
An a 2nd problem, similar to the original problem but with a "stock"
chart: In the Data Ranges > Data Series > Data ranges, I have specified
High Values and Low Values, while in the Categories area there are the A
column date values, and the bars in the chart appear OK. Again, how can
I make the X axis dates appear every 30 days? Again in Format > Axis >
X-Axis > Scale all the top fields and their Automatic checkboxes are
grayed out.
Eustace
--
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]
