GCFLearnFree.org

This course is designed better than some classes I’ve taken in school.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel XP
  • Creating a Chart

Excel XP

Single page view print copy

Creating a Chart

Identifying the Parts of a Chart

Have you ever read something you didn't fully understand but when you saw a chart or graph, the concept became clear and understandable? Charts are a visual representation of data in a worksheet. Charts make it easy to see comparisons, patterns, and trends in the data.

Relationship Between Data Source and Chart

Source Data

The range of cells that make up a chart. The chart is updated automatically whenever the information in these cells change.

Title

The title of the chart.

Legend

The chart key, which identifies each color on the chart represents.

Axis

The vertical and horizontal parts of a chart. The vertical axis is often referred to as the Y axis, and the horizontal axis is referred to as the X axis.

Data Series

The actual charted values, usually rows or columns of the source data.

Value Axis

The axis that represents the values or units of the source data.

Category Axis

The axis identifying each data series.

previous next
previous 1 2 3 4 5 6 7 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.