Understanding data series

Abstract

In this video, we’ll take a closer look at data series.

In the Select Data Source window, data series are listed on the left.

You’re free to edit this information manually.

So what are the values listed on the right side of Select Data Source window?

In short, this chart pulls data series names from columns, and axis labels from rows.

If I grab the Switch Row/Column button, this is reversed.

The data series now come from rows and axis labels come from columns.

Again, notice the legend lists data series names.

you’re free to edit the SERIES formula if you like.