Understanding How Microsoft Excel Organizes To-be-charted Data

How Excel Sees Chart Data

To easily use Excel for charting, you need to learn three key terms: data points, data series,

and data categories.Data Points are the Basic Building Blocks

The individual values you plot in a chart are called data points. Because a chart visually represents one or more numeric values, data points are always values. Note, however, that most Excel formula results are also numeric, which means that you can also plot formulas.

Read more ...