How To Make A Graph Comparing Two Sets Of Data

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

In this article, we are going to run into how to brand combination charts from a set of 2 unlike charts in Excel using the example shown below.

Example: Consider a famous coaching institute that deals with both gratuitous content in their YouTube channel and also have their own paid online courses. There are broadly two 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 likewise as bought paid online courses.

So, the institute asked their Sales Department to make a statistical 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 bear witness the percent of students who accept enrolled in these paid courses.

Table :

Here, the first data is "Number of Paid courses sold" and the second one is "Percentage of Students enrolled". Now our aim is to plot these ii data in the aforementioned chart with different y-axis.

Implementation :

Follow the beneath steps to implement the same:

Stride one: Insert the data in the cells. Afterwards insertion, select the rows and columns by dragging the cursor.

Step two: Now click on Insert Tab from the top of the Excel window so select Insert Line or Expanse Chart. From the popular-down menu select the first "2-D Line".

From the above nautical chart we tin discover that the second data line is almost invisible because of scaling. The present y-axis line is having much higher values and the percentage line will be having values bottom than 1 i.e. in decimal values. Hence, we need a secondary axis in order to plot the ii lines in the aforementioned chart. In Excel, it is besides known as clustering of two charts.

The steps to add a secondary axis are as follows :

i. Open the Chart Type dialog box

Select the Nautical chart -> Design -> Change Chart Type

Another fashion is :

Select the Chart -> Right Click on information technology -> Change Chart Type

two. The Chart Type dialog box opens. At present go to the "Philharmonic" choice and check the "Secondary Axis" box for the "Percentage of Students Enrolled" column. This will add together the secondary axis in the original chart and will dissever the two charts. This volition result in amend visualization for analysis purposes.

The combination chart with two data sets is at present ready. The secondary centrality is for the "Percentage of Students Enrolled" column in the data set as discussed above.

Now various formatting can be 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 Centrality Dialog Box

Changing the Bounds of Secondary Axis

Y'all can further format the in a higher place nautical chart past making it more interactive by changing the "Chart Styles", adding suitable "Axis Titles", "Chart Title", "Data Labels", changing the "Chart Type" etc. It can exist done using the "+" push button in the top right corner of the Excel chart.

Finally, after all the modification, the chart with multiple data sets looks like :

Nosotros can infer from the in a higher place chart that in the year 2019, the pct of students who enrolled in the online paid courses are relatively less only in 2020 more students have enrolled in paid courses than free content on YouTube.