We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Calc: insert text next to the chart's Data Points. [closed]

asked 2013-10-09 02:51:56 +0200

vatus gravatar image

It seems that one would expect that it would be possible to insert a text next to the chart's Data Points in Calc. But I failed to figure out how. So, it appears that Calc does not have such function. Am I right? Should Calc have such function?

Thanks, Vatus

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-14 12:33:12.532953

1 Answer

Sort by » oldest newest most voted

answered 2013-11-12 22:22:41 +0200

Regina gravatar image

Data labels are generated from the "category" range. For most chart types that is the same as the x-axis. But for xy-chart and bubble-chart you use a separate column in your data range. In most cased you need to edit the data series, because the wizard often does not get it correctly. The category range is the lowest field in the data series dialog page. But make sure, that the other roles are set proper too. The wizard tends to mix things up, if a category column is included for a xy-chart or bubble-chart.

To view the data label set the chart in edit mode. Then you can use Insert > Data label, or you select a single data series or even a single data point and use the context menu. To show text, you have to select the format 'show category' (and of cause have previously entered some text in the additional column) . You cannot move the text freely, but there are some positions to choose from the drop-down list in the format dialog.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-10-09 02:51:56 +0200

Seen: 9,172 times

Last updated: Nov 12 '13