Chart Properties dialog box – Series tab
Chart Properties shortcut menu > Chart – Series tab
Lets you change various options regarding data series in a chart. To edit the options for a data series, first select the series in the list box on the left side of the dialog box, then use the settings described below.
Series name
Each series should have a name to identify it in the legend. If you opted to have the first row of the table (on which the chart is based) treated as containing series names, then each series will already have a name. You can name or rename the selected series by typing a new name here.
Plot series
Select whether to plot the selected series on the Primary axis or the Alternate axis.
Data labels
You can have labels appear at each data point in the selected series. The labels can show either the Series name or the Data value; select the desired label type from the drop-down menu.
3D pie chart options
These options are only available for pie and doughnut charts.
Pull slice out
The slice representing the selected series will be “pulled out” from the rest of chart.
Raise slice up
The slice representing the selected series will be raised above the rest of the chart.
Error bar format
You can have error bars appear at each data point in the selected series. Select an error bar format in the Error bar format drop-down menu, then choose an error type by clicking one of the radio buttons underneath it.
Legend position
You can choose the position for the legend relative to the chart by using the four radio buttons arranged in a diamond pattern at the right side of the dialog box. (This setting is not series-specific.) Select Hide legend if you don’t want the legend to be visible.
Related topics
Chart Properties dialog box – Chart Type tab
Chart Properties dialog box – Title tab
Chart Properties dialog box – Values tab
Chart Properties dialog box – Trendlines tab
Chart Properties dialog box – Axis tab
Chart Properties dialog box – Chart Formatting tab