Customization Options for Charts

There are two ways to open the Chart Editor.

• Double-click a chart.
• From the chart menu, select Edit Chart.

Data Tab

Under the Data tab, you can see and adjust how the data is treated.

• Range: Specify which cells you want to include in the chart.
• X-Axis: Specify the cell range for the chart’s X-axis.
• Y-Axis (Bubble charts only): Specify the cell range for the chart’s Y-axis.
• Series: Add additional cell ranges to the chart as data series.
• Sizes (Bubble charts only): Specify the cell range for the bubble sizes.
• Switch rows and columns: Change the axis on which rows and columns are plotted.
• Use first row as headers: Use column titles as chart labels, and leave them out of the data range.
• Use first column as labels: Use row titles as chart labels, and leave them out of the data range.

Customize Tab

Under the Customize tab, you can see or change the chart type, and change the chart’s appearance. The customization options that are available depend on the chart type.

• Chart Type: Select a new chart type, add a title to the chart, and choose stacking options for column, bar, and area charts.
• Style: Choose where to show the chart legend. Change the chart’s background color or border color.
• Series: Apply data labels to one or more data series in the chart, and choose the labels’ position and text color.
• Horizontal Axis: Add an axis label. Set the minimum and maximum data range, and change the intervals between the tick marks. Update the number format for the data range. Reverse the axis order.
• Vertical Axis: Add an axis label. Set the minimum and maximum data range, and change the intervals between the tick marks. Update the number format for the data range. Show grid lines in the chart.