Charts in Excel: Data Series

• Selecting a data source
• Row column
• Adding, editing, deleting and moving

Rows or columns of numbers that are plotted on a graph are called data series. You can plot one or more data series on a chart.

To create a histogram, follow these steps:

1. Highlight a range A1:D7.
2. On the Advanced tab Insert (Insert) in section Diagrams (Charts) click Insert histogram > Histogram with grouping (Column > Clustered Column).

Selecting a data source

To open a dialog box Selecting a data source (Select Data Source) do the following:

1. Select a chart. Right click on it and press Select data (Select Data).A dialog box will appear Selecting a data source (Select Data Source).
2. On the left you can see three data series (Bears, Dolphins and Whales) and on the right the horizontal axis labels (Jan, Feb, Mar, Apr, May and Jun).

Row column

If you click on the button Row column (Switch Row/Column), you get six data series (Jan, Feb, Mar, Apr, May, and Jun) and three horizontal axis labels (Bears, Dolphins, and Whales).

Result:

Adding, editing, deleting and moving

You can use the dialog Selecting a data source (Select Data Source) for adding, editing, deleting and moving data series, but there is a faster way. Select the chart and simply change the range on the sheet.

Result: