Divine Excel Line Chart With Two Sets Of Data

Create a 2D Line Chart in Excel.

Excel line chart with two sets of data. Start a new spreadsheet and enter the same data as below. For this last chart well compare the viewing figures of BBC1 and ITV. Insert a pivot table select your entire data range including headers.

Now click on Insert Tab from the top of the Excel window and then select Insert Line or Area Chart. Youll need some data of course. To do this right click on the chart and then click select data and then rename the legend entries by clicking on the first legend entry and inputting 2017 into the Name field and then doing the same for the 2 nd Once this is done click OK and you now have your completed chart.

Im trying to create a graph with a single line plotted from two sets of data one on the x-axis- the other on the y-axis. Ask Question Asked 3 years 6 months ago. Next choose an option called Combo from the parent group titled All Charts A benefit of using Microsoft Excel as a spreadsheet application is that it displays simple information just as clearly as it does more complex graphs.

Following the below steps you will find that making two y axes in chart is very easy. Show how to use MS Excel 2013 to plot two linear data sets on the same graph so that they can be visually compared. I wonder if there is some way also using VBA if needed to create a stacked column chart displaying two different data sets in MS Excel 2016.

After insertion select the rows and columns by dragging the cursor. From the above chart we can observe that the second data line is almost invisible because of scaling. Select Person Date and Size in the field list.

Once you have. I am new here although I have been browsing the blog several times before. Highlight both columns of data and click Charts Line and make your selection.