Creating a Chart

Excel XP charts let you illustrate your workbook data graphically to see trends. Also use charts in Excel XP to visualize comparisons.

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 data.

Relationship Between Data Source and Chart

Source data

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

Title

This is the title of the chart.

Legend

This is the chart key, which details what each color on the chart represents.

Axis

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

Data series

This is the actual charted values, which usually are rows or columns of the source data.

Value axis

This is the axis that represents the values or units of the source data.

Category axis

This is the axis identifying each data series.