Microsoft Office Tutorials and References
In Depth Information
In this exercise, you’ll add a trendline to a chart.
SET UP You need the FutureVolumes_start workbook located in your Chapter10
practice file folder to complete this exercise. Open the FutureVolumes_start
workbook, and save it as FutureVolumes . Then follow the steps.
1. Select the chart.
2. On the Layout contextual tab, in the Analysis group, click Trendline , and then
click More Trendline Options .
The Format Trendline dialog box opens.
3. If necessary, in the Trend/Regression Type area, click Linear .
4. In the Forecast area, in the Forward field, type 3 .
5. Click Close .
Excel adds the trendline to the chart.
CLEAN UP Save the FutureVolumes workbook, and then close it.
Summarizing Your Data by Using Sparklines
You can create charts in Excel workbooks to summarize your data visually, by using
legends, labels, and colors to highlight aspects of your data. It is possible to create
very small charts to summarize your data in an overview worksheet, but you can also
use sparklines, which are new in Excel 2010, to create compact, informative charts that
provide valuable context for your data.
Edward Tufte introduced sparklines in his book Beautiful Evidence (Graphics Press, 2006),
with the goal of creating charts that imparted their information in approximately the same
space as a word of printed text. In Excel 2010, a sparkline occupies a single cell, which makes