In article <[email protected]>, Brian Barker <[email protected]> wrote:
> 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. Okay. That I would have to figure out if not for your comments below. > >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. Wonderful! That is exactly what I needed. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
