To remove the label of an individual data point, carefully follow this procedure:

Guess which pie chart uses Best fit and which uses Outside. Labels on pie charts have the new option Best fit with an algorithm to prevent overlapping labels. Improved automatic positions for labels on pie charts What's the difference between outside and above? When the values are negative, outside acts like below. For pie charts, the options are best fit, outside, inside, and center. For bar charts, the options are right, left, center, outside, inside, and near origin.

Then, in the Data Labels dialog, choose an option from Placement.įor column charts the options are above, below, center, outside, inside, near origin.

To set the placement for either all the labels or individual labels, select either all the data labels or an individual data label (respectively). There are many new options for placing data labels. More flexible placement of labels on data points In the Data Labels dialog, check the box Show value as number. The Separator option is disabled unless you check two or more of the first three check boxes.īefore data labels always pulled their number formats from the source data. In the Data Labels dialog, change Separator to New line. Display each part of a data label in a separate lineĪs the amount of information in a data label grows, it may be necessary to move some onto a separate line. In the Data Labels dialog, check the boxes Show value as number and Show value as percentage. Display both value and percentageĬan't decide between showing the value and showing the percentage? Show both.

Click Insert > Data Labels from the menu.Īfter the labels are inserted, their options can be updated anytime from the same place (despite the use of the term Insert) or by right clicking on the data series in the chart, choosing Object Properties, and then clicking on the Data Labels tab.

You should notice most buttons disappear from the toolbar.

If you are not already in chart mode, double click the chart to enter chart mode.

To use any of these improvements, you will need data labels. 2.4 brings six improvements to data labels in charts.

Openoffice calc graph add data