Microsoft Office Tutorials and References
In Depth Information
10 Creating Charts
In this chapter, you will learn how to
✔ Create charts.
✔ Customize the appearance of charts.
✔ Find trends in your data.
✔ Summarize your data by using sparklines.
✔ Create dynamic charts by using PivotCharts.
✔ Create diagrams by using SmartArt.
✔ Create shapes and mathematical equations.
When you enter data into a Microsoft Excel 2010 worksheet, you create a record of
important events, whether they are individual sales, sales for an hour of a day, or the
price of a product. What a list of values in cells can’t communicate easily, however, is
the overall trends in the data. The best way to communicate trends in a large collection
of data is by creating a chart, which summarizes data visually. In addition to the
standard charts, with Excel 2010 you can create compact charts called sparklines, which
summarize a data series using a graph contained within a single cell.
You have a great deal of control over your charts’ appearance—you can change the color
of any chart element, choose a different chart type to better summarize the underlying
data, and change the display properties of text and numbers in a chart. If the data in the
worksheet used to create a chart represents a progression through time, such as sales over
several months, you can have Excel extrapolate future sales and add a trendline to the
graph representing that prediction.
Just as you can create a PivotTable dynamic view to reorganize your data dynamically,
you can create a PivotChart dynamic view that reflects the contents and organization of
the associated PivotTable. You can also add shapes, display mathematical equations, and
create diagrams, such as organizational charts, that are useful in many organizations.