From the pop-down menu select the first “2-D Line”.įrom the above chart we can observe that the second data line is almost invisible because of scaling. Step 2: Now click on Insert Tab from the top of the Excel window and then select Insert Line or Area Chart. After insertion, select the rows and columns by dragging the cursor. Implementation :įollow the below steps to implement the same: Now our aim is to plot these two data in the same chart with different y-axis. Here, the first data is “Number of Paid courses sold” and the second one is “Percentage of Students enrolled”. 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 last year 2020 and also show the percentage of students who have enrolled in these paid courses. The students who enrolled as well as bought paid online courses.
#Excel add second line in cell free#
The students who enrolled in the coaching but are learning from YouTube free video content.There are broadly two categories of students in this institute :
#Excel add second line in cell how to#
In this article, we are going to see how to make combination charts from a set of two different charts in Excel using the example shown below.Įxample: Consider a famous coaching institute that deals with both free content in their YouTube channel and also have their own paid online courses. This type of chart having multiple data sets is known as “Combination charts”. Sometimes while dealing with hierarchical data we need to combine two or more various chart types into a single chart for better visualization and analysis.
How to Enable and Disable Macros in Excel?.Positive and Negative Trend Arrows in Excel.How to Remove Pivot Table But Keep Data in Excel?.How to Automatically Insert Date and Timestamp in Excel?.How to Find Duplicate Values in Excel Using VLOOKUP?.How to Show Percentage in Pie Chart in Excel?.Highlight Rows Based on a Cell Value in Excel.How to Find Correlation Coefficient in Excel?.How to Remove Time from Date/Timestamp in Excel?.ISRO CS Syllabus for Scientist/Engineer Exam.ISRO CS Original Papers and Official Keys.GATE CS Original Papers and Official Keys.