Chart Labels

To ensure that your charts are easy to understand, you can customize the positions of data labels so they are clearly visible.

Labels for Chart Series

To set label positions for a single series in a chart, go to the Series tab and choose a series to work with from the drop-down menu at the top. You can also click on a series or data point in the chart to activate it.

You can use the Shown/Hidden slider to turn the data point labels on and off for your chart series. The Position drop-down that appears when labels are shown allows you to select the position of the data value labels in relation to the data point.

image alt text

Single Point Labels

If you need to draw attention to a single point, you can use the Single Point Settings at the bottom of the panel to work with each point individually. First hide the labels for the series, then select the point in the drop-down or click on a point in the chart. Now you can choose Show Label under Single Point Settings.

If you are working with an area chart, the same label options are available. Check to see that your labels are visible against the shaded areas.

Labels for Column Charts

In a column chart, the position options are Outside End, Inside End, and Middle. The same options apply to bar charts, stacked column charts, stacked bar charts, and waterfall charts.

Also note that you can show total labels for stacked column and bar charts as well. Go to the Main tab and then the Advanced section at the bottom of the panel. Check the box for Show Total Labels.

Labels for Pie and Doughnut Charts

In pie and doughnut charts, all labels are positioned outside of the pie with a connector to each slice individually. Label positions move with the rotation of the chart using the control in the Main panel. As you adjust the diameter, the length of the connectors also adjust. You can also adjust the distance and width of the labels with sliders to control the look and placement of the slice labels.

You can also change the precision of labels, as well as the color and thickness of the line connecting a label to the chart.

image alt text

Labels for Scatter and Bubble Charts

Labels in scatter charts and bubble charts can be turned on and off for the whole chart in the Main tab or for each point under Series. Placement options include top, bottom, left, right and middle.