Mailinglist Archive: opensuse (6210 mails)

< Previous Next >
Re: [SLE] OpenOffice 2.0
  • From: Bruce Marshall <bmarsh@xxxxxxxxxx>
  • Date: Mon, 3 Oct 2005 15:15:27 -0400
  • Message-id: <200510031515.27657.bmarsh@xxxxxxxxxx>
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.

< Previous Next >
References