Microsoft Office Tutorials and References
In Depth Information
Chapter 9: Creating charts and graphics
Creating charts and
IN THIS CHAPTER, YOU WILL LEARN HOW TO
▪ Create charts.
▪ Customize the appearance of charts.
▪ Find trends in your data.
▪ Create dual-axis charts.
▪ Summarize your data by using sparklines.
▪ Create diagrams by using SmartArt.
▪ Create shapes and mathematical equations.
When you enter data into a Microsoft Excel 2013 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. However, a list of values in cells can’t communicate easily 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 2013, you can
create compact charts called sparklines, which summarize a data series by 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 that represents that prediction.
In this chapter, you’ll create a chart and customize its elements, find trends in your data,
create a dual-axis chart, summarize data by using sparklines, create diagrams by using
SmartArt, and create shapes that contain mathematical equations.