OpenOffice Chart Question
September 18, 2007 8:47 AM Subscribe
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.
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.
Response by poster: 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
posted by vilcxjo_BLANKA at 9:03 AM on September 24, 2007
This thread is closed to new comments.
posted by anaelith at 9:24 AM on September 18, 2007