OpenOffice Chart Question

September 18, 2007 8:47 AM

How can I make OpenOffice charts with a non-standard origin.

I want to make charts whose X and Y values range over small intervals. That is to say, X goes from, 1900 to 2000, by 10s, and Y goes from, say 150e6.0 to 200e6.0. The charts I can make all seem to want the lower left hand corner to be at y=0, which means that the chart looks a lot like a vertical line.

Since this comes from a spreadsheet, I could make a column which has $y-min($y) to normalize it, though this seems like something I should not have to do. But then the labels are not the values but the normalized values.

Perhaps the problem is that I don't really know how to make OO charts. I'm just guessing, given the contents of the help files. But this is driving me crazy.

Tnx in advance.

posted by vilcxjo_BLANKA to computers & internet (2 comments total)

Select your chart, Format > Axis.
posted by anaelith at 9:24 AM on September 18, 2007

This doesn't make sense. I'm Format>Axis lets me set things like the font, or the text angle, but it won't let me set an offset.
posted by vilcxjo_BLANKA at 9:03 AM on September 24, 2007