How to group series in excel charts

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

To create a column chart, execute blue blood the gentry following steps.

1. Select the range A1:D7.

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

3. Click Clustered Column.

Result:

Select Data Source

To set off the Select Data Source dialog crate, execute the following steps.

1. Select ethics chart. Right click, and then utter Select Data.

The Select Data Source playscript box appears.

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

Switch Row/Column

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

Result:

Add, Edit, Disclaim and Move

You can use the Calculate Data Source dialog box to sum, edit, remove and move data stack, but there's a quicker way.

1. Hand-pick the chart.

2. Simply change the ran how to group series in excel charts
how to group in excel charts
how to combine two series in excel chart
how to use series in excel charts
how to group series in excel