Brian:
Thanks. I used your second suggestion and I could produce
labels for two of the three columns. Strangely, I could not
produce the third and I can't figure out why.
Fred
On 11/23/14 5:05 PM, Brian Barker wrote:
At 10:36 23/11/2014 -0800, Fred Conly wrote:
I use OpenOffice 3.4.1 with Windows 7 Home Premium 64-bit. I'm only
an occasional chart maker. I created a chart years ago, of Column,
Stacked, with three Data Sets. Will some kind person please remind me
how to change the text in the Legend for the three Data Sets?
o Double-click the chart to select it - so you see the grey border,
not just the eight coloured handles.
o The source cells for the legend text should be highlighted in the
spreadsheet - either as column (or row) titles for the data ranges or
else independently.
o If so, modify the text there.
If not - and especially if the legend text is "Column X" and so on -
you can set up a table for the legend:
o Enter the required legend text into separate suitable cells anywhere
in the spreadsheet.
o Double-click the chart to select it - so you see the grey border,
not just the eight coloured handles.
o Go to Format | Data Ranges... | Data Series (or right-click | Data
Ranges... | Data Series).
o Select each data series in turn in the "Data series" column and
select Name in the "Data ranges" column.
o Next to "Range for Name", click the "Select data range" button.
o Click the relevant cell.
o Repeat for other data series.
At 15:00 23/11/2014 -0800, Fred Conly wrote:
I'm using Open Office Calc. There are three Columns of Data I used
for the Chart. I must have started the Data Range /below /the Column
Headings. Hence the three Labels appearing in the Legend, each
preceded by a Square object with the same color or shading in the
Column Bar as the Data Series it represents, with the three Texts
reading: Column E, Column D, and Column C. It is these Texts I would
like to change.
I suppose I could change the Data Ranges to include the Column
Headings. If that's the easiest way then I need a reminder of how to
do that.
To do it that way:
o Double-click the chart to select it - so you see the grey border,
not just the eight coloured handles.
o Go to Format | Data Ranges... | Data Series (or right-click | Data
Ranges... | Data Series).
o Select each data series in turn in the "Data series" column and
select "y-Values" in the "Data ranges" column.
o Next to "Range for y-Values", click the "Select data range" button.
o Ignore the existing marked range (without the column heading) and
drag over the correct range - now including the heading.
o Repeat for other data series.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
