At 11:35 03/10/2010 -0400, Robert Peirce wrote:
I am virtually certain I can't do this in excel. Can I do it in OO?
Yes, you can do this in OpenOffice, and - dare I admit it here? - you
can do it in Excel too.
Usually, what I want to plot is some kind of price index along with
some sort of economic series. Their values are going to wildly
different. The price series might be 20,000, while the economic
series is 1.8. I want both to fill most of the chart. Putting the
scales on opposite sides would be great but not critical. If
anybody has a method to do this, I would appreciate seeing it.
o Create your chart in the normal way.
o Double-click the chart to select it - so that you see the grey border.
o Click one of the data points; the data series is marked with green
squares and the relevant column (or row) in the spreadsheet is
outlined in blue.
o Go to Format | Object Properties... | Options (or right-click |
Object Properties... | Options).
o Under "Align data series to", select "Secondary Y axis".
o You can repeat this for other data series if necessary if you have
more than two series in your chart.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
