Data Series in Excel | Data Series Definition

Data Series in Excel

A data series is used to create a Chart. A data series is a group of rows and columns. It is necessary to have a data series when we want to move from table view to chart view. One or more data series can be plot in a chart. We first need to create a chart and then alter it with the various ways.

Steps to Add Data Series are:

Step 1: Select the range of cells or Highlight the cells. Here A1:C5 range is selected

Data Series - Data Example

Step 2: Go to the Insert Tab, Chart group, Click on Column Chart. From the drop down menu, Select the Clustered Column chart

Data Series - Clustered Column Chart

Step 3: The result that is the clustered chart will be displayed in the worksheet.

Data Series - Clustered Column

To change the data series in a chart, you have two ways:

1. Add Data Series to the Chart

Chart located in the Same Worksheet:

After you have created the chart, you might need to add additional series to the chart which is located in the same worksheet. Here we have added Percentage series next to the Profit column. Percentage will be calculated by typing the percentage formula or  =C2/B2*100. Use the fill handle to find the percentage for the remaining regions.

Steps to add data series to the existing chart in the Same Worksheet is as follows:

Step 1: Add a new data series next to or below the existing data series.

Data Series - Data Example 2

Step 2: Click on the chart. You see that the data which you added new is not selected in the data series in Excel.

Data Series - Example Selected

Step 3: Drag the Selection area to the new data series as well.

Data Series - Select Whole Data

Step 4: You will see that your chart is updated automatically.

Data Series Chart

Chart located in the New Worksheet:

After you have created the chart, you might need to add additional data series to the chart which is located in another worksheet. Here it won’t be a great idea to add drag the selection as you did while adding data series to the chart in the Existing worksheet. Steps to add data series to chart located in another worksheet is as follow:

Step 1: Add a new data series next or below the Existing data series.

Data Series - Data Example 3

Step 2: Click on the worksheet where your chart is located.

Step 3: Right click on to the chart and Click on Select Data.

Data Series - Select Data

Step 4: The Select Data Source dialog pops up.

Data Series - Select Data Source

a. Click in the worksheet, and then click and drag to select the data you want to add to the chart new as well as existing.

b. Data series will appear under Legend Entries

Data Series - Select Data Source 2

Step 5: Click on Ok

Data Series Chart 2

2. Use Chart filters to show or Hide Data

Steps to filter the chart are:

Step 1: Click anywhere inside the Chart.

Data Series Chart 2

Step 2: Click on the Filter button to the right of the chart

Data Series - Select Filter

Step 3: On the Values tab, check or unchecked the boxes you want to hide or show

Data Series - Select Filter unchecked

Step 4: Click on Apply

Data Series - filter Chart

Hope you like our tutorial for more cool and amazing trick of excel Like our Excel Superstar Facebook Page and subscribe to our Excel Superstar YouTube channel. Excel Superstar is the leading online training company, which provides Online Excel Course in Hindi. Connect with us and become an Excel Superstar.