Microsoft Office Tutorials and References
In Depth Information
Customizing the Appearance of Charts
If you want to change a chart’s appearance, select the chart and then, on the Design tab,
click a style in the Chart Styles gallery. The gallery contains far more chart styles than are
shown on the ribbon—to select a new look for your chart, click the More button at
the gallery’s lower-right corner, and then click the design you want.
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 Insert tab’s Charts group, 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 the layout you want.
If you don’t find the exact chart layout you like, you can use the tools on the Layout
contextual tab to control each element’s appearance and placement.