Microsoft Office Tutorials and References
In Depth Information
Customizing the appearance of charts
TIP The styles in the Chart Styles gallery are tied to your workbook’s theme. If you change
your workbook’s theme, Excel changes your chart’s appearance to reflect the new theme’s
When you create a chart by using the tools in the Charts group on the Insert tab, Excel
creates an attractive chart that focuses on the data. In most cases, the chart has a title, legend
(list of data series displayed in the chart), horizontal lines in the body of the chart to make
it easier to discern individual values, and axis labels. If you want to create a chart that has
more or different elements, such as additional data labels for each data point plotted on
your chart, you can do so by selecting the chart and then, on the Design tab, in the Chart
Layouts group, clicking Quick Layouts and then clicking the layout you want.
If you don’t find the exact chart layout you want, you can select the chart and then click the
Chart Elements action button, which appears to the right of the chart, to control each
element’s appearance and options.
By selecting the Gridlines check box, you can determine whether the chart displays
horizontal and vertical gridlines.
In addition to changing your chart’s layout, you can control the appearance of each
element within the chart. To select a chart element to format, click that element. For example,
if you want to change the formatting of the data series named Volume in the column chart
you created in the previous exercise, you can click any column in the series to select the
entire series. Any formatting changes you make then apply to every point in the entire series.
If you want to change a single data point, select the entire series, and then click the chart
element (for example, a column) that represents the data point that you want to change.
For example, you can highlight the column that represents the year 2011 in the chart you
created in the previous exercise.