Microsoft Office Tutorials and References
In Depth Information
Changing the Chart Options
2. Choose Chart Tools Design>Data>Select
Data. The Select Data Source dialog box
opens with the current chart data selected in
the worksheet (see Figure 13-22).
Even if you don’t like some of the predefined
options, you can still change any chart options
individually. Right-click on any element you want to
change and select Format (chart item). Most changes
can be made directly from the Format dialog box.
Just follow these steps to apply a chart style:
Click anywhere on the chart you want to
2. Choose Chart Tools Design>Chart Styles and
click the More button, which displays the
Chart Styles gallery seen in Figure 13-23. This
figure illustrates the chart styles based on
the Metro theme.
The Select Data Source dialog box.
3. Drag in the worksheet to select the new data
range. The Select Data Source dialog box
collapses so you can easily see your data.
See Chapter 10, “Making Your Worksheet
Look Good,” for a refresher on themes.
Optionally, type the cell location in the Chart
Release the mouse button. The Select Data
Source dialog box reappears, and the new data
range appears in the Chart data range box.
5. Click OK. The Select Data Source dialog box
closes and the chart reflects the new data area.
Selecting a chart style.
Altering the Chart Color Style
You’ve already discovered how you can quickly
change many options on your chart. You can also
change the look by applying any of the many
predefined chart styles. Chart styles are based on the
current Excel workbook’s theme, and include
options such as colors and fonts.
3. Select a chart style. You may need to scroll
down. The available styles vary depending on
the chart type.