spot_img

Data Series

 

Select Data Source | Switch Row/Column | Add, Edit, Remove and Move

A row or column of numbers that are plotted in a chart is called a data series. You can plot one or more data series in a chart.

To create a column chart, execute the following steps.

1. Select the range A1:D7.

Select a Range in Excel

2. On the Insert tab, in the Charts group, click the Column symbol.

Insert Column Chart

3. Click Clustered Column.

Click Clustered Column

Result:

Column Chart in Excel

Select Data Source

To launch the Select Data Source dialog box, execute the following steps.

1. Select the chart. Right click, and then click Select Data.

Select Data

The Select Data Source dialog box appears.

2. You can find the three data series (Bears, Dolphins and Whales) on the left and the horizontal axis labels (Jan, Feb, Mar, Apr, May and Jun) on the right.

Select Data Source

Switch Row/Column

If you click Switch Row/Column, you’ll have 6 data series (Jan, Feb, Mar, Apr, May and Jun) and three horizontal axis labels (Bears, Dolphins and Whales).

Switch Row/Column

Result:

Switched Column Chart

Add, Edit, Remove and Move

You can use the Select Data Source dialog box to add, edit, remove and move data series, but there’s a quicker way.

1. Select the chart.

2. Simply change the range on the sheet.

Result:

Change Range on Sheet

spot_img
Previous articleCount Blank/Nonblank Cells in Excel
Next articleDynamic Named Range in Excel