How To Create A Graph With 3 Sets Of Data

Sometimes while dealing with hierarchical data we demand to combine two or more various chart types into a single chart for better visualization and analysis. This type of chart having multiple information sets is known as "Combination charts".

In this article, we are going to see how to brand combination charts from a set of two unlike charts in Excel using the case shown below.

Instance: Consider a famous coaching plant that deals with both gratuitous content in their YouTube channel and also have their ain paid online courses. There are broadly 2 categories of students in this institute :

The students who enrolled in the coaching but are learning from YouTube free video content.
The students who enrolled as well as bought paid online courses.

So, the constitute asked their Sales Department to make a statistical nautical chart about how many paid courses from a pool of courses which the institute deals with were sold from the year 2014 to the concluding year 2020 and as well show the per centum of students who have enrolled in these paid courses.

Table :

Here, the beginning data is "Number of Paid courses sold" and the second one is "Percent of Students enrolled". At present our aim is to plot these two information in the same nautical chart with dissimilar y-axis.

Implementation :

Follow the below steps to implement the same:

Step 1: Insert the data in the cells. Later insertion, select the rows and columns past dragging the cursor.

Stride 2: Now click on Insert Tab from the peak of the Excel window so select Insert Line or Expanse Nautical chart. From the pop-downwardly card select the beginning "2-D Line".

From the above chart nosotros can find that the 2d information line is almost invisible because of scaling. The nowadays y-centrality line is having much higher values and the per centum line will exist having values lesser than one i.e. in decimal values. Hence, we demand a secondary centrality in guild to plot the ii lines in the aforementioned nautical chart. In Excel, it is also known as clustering of two charts.

The steps to add a secondary axis are every bit follows :

1. Open

strong> Chart Type dialog box

Select the Chart -> Design -> Change Chart Type

Another way is :

Select the Chart -> Right Click on it -> Change Chart Blazon

ii. The Chart Blazon dialog box opens. At present go to the "Philharmonic" option and check the "Secondary Axis" box for the "Percentage of Students Enrolled" column. This will add the secondary axis in the original chart and will separate the two charts. This will effect in ameliorate visualization for analysis purposes.

The combination chart with two data sets is at present ready. The secondary axis is for the "Per centum of Students Enrolled" column in the data set as discussed higher up.

At present various formatting tin exist carried out in this secondary axis using the Format Axis window on the right corner of Excel.

Select the secondary Axis -> Right Click -> Format Axis -> Format Axis Dialog Box

Changing the Bounds of Secondary Axis

You can further format the in a higher place chart by making it more interactive by irresolute the "Chart Styles", adding suitable "Axis Titles", "Chart Title", "Information Labels", changing the "Nautical chart Type" etc. It can be done using the "+" push in the top correct corner of the Excel nautical chart.

Finally, later on all the modification, the nautical chart with multiple data sets looks like :

We can infer from the in a higher place chart that in the twelvemonth 2019, the percentage of students who enrolled in the online paid courses are relatively less but in 2020 more students have enrolled in paid courses than free content on YouTube.