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
Step 2: Go to the Insert Tab, Chart group, Click on Column Chart. From the drop down menu, Select the Clustered Column chart
Step 3: The result that is the clustered chart will be displayed in the worksheet.
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.
Step 2: Click on the chart. You see that the data which you added new is not selected in the data series in Excel.
Step 3: Drag the Selection area to the new data series as well.
Step 4: You will see that your chart is updated automatically.
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.
Step 2: Click on the worksheet where your chart is located.
Step 3: Right click on to the chart and Click on Select Data.
Step 4: The Select Data Source dialog pops up.
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
Step 5: Click on Ok
2. Use Chart filters to show or Hide Data
Steps to filter the chart are:
Step 1: Click anywhere inside the Chart.
Step 2: Click on the Filter button to the right of the chart
Step 3: On the Values tab, check or unchecked the boxes you want to hide or show
Step 4: Click on Apply
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.
Follow Excel Superstar
