On Monday 03 October 2005 03:00 pm, Mark wrote:
I'd just like a little verification. All I can get out of OO now is that it charts both of the columns on the graph and uses row1, row2, row3 for the X values. I've found no way to tell it to treat col1 as the X value and col2 as the Y value.
If I understand what you're tring to do, you want to tell OO that you're creating a XY chart. On the second screen during the "AutoFormat Chart" dialog select the "XY Chart" option.
In all of my attempts, that didn't change a thing. Only selecting the 'First column has labels' did anything and there are still problems with charting. 1) Given many, many data points (as in more than 100 say), you're not going to be able to read the values on the X axis... They all run together. In the April chart that I did, the chart used only 1 out of about 32 data points on the X axis which rendered the dates as very readable and they were all horizontal, not this vertical stuff. I had 334 data pairs. 2) The chart starts at 0 and doesn't do a nice 'fit' on the Y axis. The april chart does that and renders a really nice graph of the values.