Excel 2016 All-in-One For Dummies

Chapter 1

Charting Worksheet Data

In This Chapter

Understanding how to chart worksheet data

Creating an embedded chart or one on its own chart sheet

Editing an existing chart

Formatting the elements in a chart

Saving customized charts as templates and using these templates to create new charts

Adding sparklines to worksheet data

Printing a chart alone or with its supporting data

Charts present the data from your worksheet visually by representing the data in rows and columns as bars on a chart, for example, or as pieces of a pie in a pie chart. For a long time, charts and graphs have gone hand-in-hand with spreadsheets because they allow you to see trends and patterns that you often can’t readily visualize from the numbers alone. Which has more consistent sales, the Southeast region ...