Chapter 15

Charting Worksheet Data

IN THIS CHAPTER

check Understanding how Excel charts worksheet data

check Creating a chart from the Insert tab of the Ribbon

check Creating a chart on a separate chart sheet

check Formatting the basic chart

check Editing a chart

Besides the actual data entry and building the formulas for a worksheet, charting the data may well be one of the most essential tasks you perform in Excel. When you present worksheet data in a visual form, relationships between the data that were not apparent in numerical form often become quite obvious. Fortunately, Excel offers you a wealth of different types of charts with which to depict these relationships. Half the fun of charting is selecting the most appropriate chart type and customizing it to your needs.

In this chapter, you get a chance to practice charting worksheet data, both in the worksheet and on separate chart sheets. You also get practice with customizing the various parts of the basic chart so that they present the data in the clearest ...

Get Excel Workbook For Dummies, 2nd Edition 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.