Microsoft Office Tutorials and References
In Depth Information
Chapter 10: Charting and Analyzing Data
Chapter 10
Charting and Analyzing Data
In This Chapter
Understanding the parts of a chart
Creating a chart
Editing a chart
Modifying the parts of a chart
Playing with pivot tables
The biggest problem with looking at any Excel spreadsheet is wondering,
“What the heck do these numbers really mean?”
To help you analyze and understand what rows and columns of numbers
might mean, Excel can convert data into a variety of charts such as pie
charts, bar charts, and line charts. By letting you visualize your data, Excel
helps you quickly understand what your data means so you can spot trends
and patterns.
Understanding the Parts of a Chart
To create charts that clarify your data (rather than confuse you even more),
you need to understand the parts of a chart and their purpose, as shown in
Figure 10-1:
Data Series: The numeric data that Excel uses to create the chart
X-axis: Defines the width of a chart
Y-axis: Defines the height of a chart
Legend: Provides text to explain what each visual part of a chart means
Chart Title: Explains the purpose of the entire chart
 
Search JabSto ::




Custom Search