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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.