At 18:58 03/10/2010 -0400, Robert Peirce wrote:
Robert Peirce wrote:
Brian Barker wrote:
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.
Oops! When I click on Format, I do not get Object Properties as a
choice. What I get are:
Format Selection...
[...]
I have version 3.1.1. for Windows; perhaps you have another. Your
"Format Selection..." is in the same place as my "Object
Properties..."; was one simply renamed as the other? Does it lead to
the option I describe?
I also discover the date column doesn't get put on the bottom of the
chart as it does in Excel, and I don't know how to get it there.
In the second step ("Data Range") of the Chart Wizard, tick "First
column as label".
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org