How to graph multiple data sets in Excel

You can watch a video tutorial here.

Graphs are great ways to visualize data and Excel has several tools for creating and formatting charts. The type of chart that you create depends on the dataset that you have. Using the charting tools in Excel, you can explore various types of charts and decide on the one that best suits the data that you are visualizing. When you have multiple sets of data that are related, you can plot them in one graph so that the relationship between the datasets is more evident. 

Step 1 – Open the Insert Chart box

– Select the first set of data
– Go to Insert > Charts
– Click the Recommended Charts option

Step 2 – Choose the chart

– Go to All Charts > Column
– Select the first chart
– Click OK

Step 3 – Open the Select Data Source box

– Select the chart
– Go to Chart Design > Data
– Click on the Select Data option

Step 4 – Open the Edit Series box

– Click the Add button

Step 5 – Add the second set of data

– For Series name, select the ‘Change’ column title
– For Series values, select the range of the ‘Change’ column
– Click OK
– Click OK in the Select Data Source box

Step 6 – Open the Change Chart Type box

– Select the columns
– Go to Chart Design > Type
– Click on Change Chart Type

Step 7 – Choose the chart type

– Expand the menu for the chart type under the ‘Change’ option
– Choose Line
– Tick the box for Secondary Axis
– Click OK

Step 8 – Design and Format the chart

– Select the chart to summon the Chart Design and Format menus
– Add more elements to the chart such as the chart title, axis titles, and legend using the Chart Design menu
– Format the chart with the options on the Format menu