Chapter 1

Charting Worksheet Data


check Understanding how to chart worksheet data

check Creating an embedded chart or one on its own chart sheet

check Editing an existing chart

check Formatting the elements in a chart

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

check Adding sparklines to worksheet data

check 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 ...

Get Excel 2019 All-in-One For Dummies now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.