Best Line Graph In Excel With Two Data Sets

From the pop-down menu select the first 2-D Line.

Line graph in excel with two data sets. Move Person to Legend Fields Date to Axis Fields and Size to Values. Combination chart or most commonly known as combo chart in excel is a combination of two or more than two different charts in excel to make such types of combo charts we can use the option of creating a combo chart from the insert menu in the chart tab also in order to combine two charts we must have two different data sets but one common field to combine. 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.

Select Person Date and Size in the field list. Enter Your Data. Under pivot table options select pivot chart and choose your desired chart type.

Excel has detected the dates and applied a Date Scale with a spacing of 1 month and base units of 1 month below left. Firstly you will need to setup your data to be able to compare month to month revenue. Part 1of 2Creating a Line Graph.

From the Insert menu we will then need to select the appropriate Line Graph. If you already have an Excel spreadsheet with data input instead double-click the spreadsheet and skip the next two steps. From the above chart we can observe that the second data line is almost invisible because of scaling.

Ad Get More Results from Your Graphs for Less Effort. Double-click the Excel program icon which resembles a white X on a green folder. Select combo from the All Charts tab.

Now click on Insert Tab from the top of the Excel window and then select Insert Line or Area Chart. 1 Select the two sets of data you want to use to create the graph. Ad Get More Results from Your Graphs for Less Effort.