Microsoft Office Tutorials and References
In Depth Information
Changing the Chart Layout
Refreshing a chart
If a chart is linked to a separate Excel workbook, you can update the chart
to reflect any changes that have been made to the underlying data. To do so,
follow these steps:
1. Click the chart to select it.
The Ribbon expands to include the Chart Tools tabs.
2. Click the Design tab on the Ribbon.
3. Click the Refresh Data button in the Data group.
The chart is updated with the data from the underlying Excel workbook.
Changing the Chart Layout
A chart layout is a predefined combination of chart elements such as legends,
titles, and so on. Microsoft studied thousands of charts and talked to chart
experts to come up with galleries of the most common layouts for each chart
type.
To change the layout for a chart, follow these steps:
1. Click the chart to select it.
The Ribbon expands to include the Chart Tools tabs.
2. Click the Design tab on the Ribbon.
3. Click the Quick Layout button.
Doing this opens the Quick Layout Gallery, as shown in Figure 13-8.
Figure 13-8: The Quick Layout Gallery for column charts.
Search JabSto ::




Custom Search