O'Reilly logo

Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables, 4th Edition by Paul McFedries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 13

Visualizing Data with Charts

Examine Chart Elements

One of the best ways to analyze your worksheet data, or get your point across to other people, is to display your data visually in a chart, which is a graphic representation of spreadsheet data. As the data in the spreadsheet changes, the chart also changes to reflect the new numbers.

You have dozens of different chart formats to choose from, and if none of the built-in Excel formats is just right, you can further customize these charts to suit your needs. To get the most out of charts, you need to become familiar with the basic chart elements.

A Category Axis

The axis (usually the X axis) that contains the category groupings.

B Chart Title

The title of the chart.

C Data Marker ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required