Ask Your Question

Put label of another data series on column

asked 2016-10-12 11:55:00 +0100

tankz gravatar image

Hi there, I'd like to present my data of 3 series on a column and line chart. One series is presented on a bar to one y-axis, and another is on a line to another y-axis. I'd like the third series to not be aligned to any axis, but just to show up as a label on or within the columns. How should I do this?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2016-10-12 14:10:03 +0100

pierre-yves samyn gravatar image


I'm not sure I understand, but I think you could use the 3rd series category for the others. See Chart.ods


edit flag offensive delete link more

answered 2016-10-12 17:00:54 +0100

mark_t gravatar image

When you create Bar + Line chart after selecting three columns of data, by default the first column is category, second is used for bar chart, third is used for line chart.

You can edit the data range of the chart to change the default column selection, either using the chart wizard during chart creation or double click the chart to put it in edit mode and use the data range icon.

You can only have one category series for any chart, (although you can set multiple columns for the category this results in two cells used to create each point in the category and only the first of those cells is formatted correctly. For example if you rotate the label of the category, only the first cells data is rotated, remainder is still horizontal.)

Instead of showing the category only on the axis label, you can also enable the data series label of a chart series and include the category in that label. First select the series in the chart, then right click and select insert data labels. Default is to label the columns value at the top of each column.

From the drop down menu at the left of the toolbar you can now select data series data labels, then click the icon to format the selection. Choose the Data Labels tab, you can then select Show Category instead of value and choose the position of the label.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-10-12 11:55:00 +0100

Seen: 588 times

Last updated: Oct 12 '16