How To Add Two Sets Of Data To One Graph In Excel

It won't be difficult adding two data series to a chart in Excel; But what to do to add a data point in a line chart? Here is the guide how to add two sets of data to one graph in Excel.

How to add single data point to a line chart in Excel

https://www.youtube.com/watch?v=U7M7SetrMmU

For example, you created a line chart as below screenshot shown:

1. First, enter the specified data point that will be added to the chart, located next to the source data

2. Right-click the line chart, and then click Select Data.

3. In the Select Data Source dialog box, click the Add button in the Legend Entries (Series) section.

4. The Edit Series dialog box will appear. (1) name the single data point in the Series name box, (2) specify the entire column including single data point as the Series value, and (3) click the OK button consecutively to close both. dialog box.

5. Continue to right-click on the line in the chart and select Change Series Chart Type

6. In the Change Chart Type dialog box, under the All Charts tab, click the Line option in the left bar, click the Line with Markers icon, and then click the OK button.

Note: If you are using Excel 2010 or earlier versions, right click on the chart and choose Change Chart Type, then click to select the Line with Markers icon in the pop-up dialog and finally click OK button

You will now see a single data point added to the line chart.

How to add a vertical axis to the right of an Excel chart

https://www.youtube.com/watch?v=r5RwETjFZNI

When creating a chart in Excel, the vertical axis is automatically added to the left. In some cases, you need to move it to the right hand, what should I do?

Let's say you have created a line chart as below screenshot shown.

The steps to add a vertical axis to the right side of the chart would be:

1. Right-click on the chart and click Select Data from the right-clicking menu.

2. In the Select Data Source dialog box, click the Add button

3. In the Edit Series dialog box, specify the exact same series name and serial value as the original series, and then click the OK button consecutively to close the Edit Series dialog box and the Select Data Source dialog box.
4. Now right click on the line in the chart and choose Change Series Chart Type from the right-clicking menu.

5. In the Change Chart Type dialog box, select the second option in the Secondary Axis column, and click the OK button.

6. Now go back to the chart again. Right click on the left vertical axis and select Format Axis in the right-clicking menu

7. In the Format Axis pane, enable Text Options, and then select the No Fill option.

That is done

Complete

Note: If you are using Excel 2010, you can add the vertical axis to the right of the chart as follows:

1. Follow Steps 1-3 like the instructions above.

2. Right click on the new line in the chart and select Format Data Series in the right-clicking menu.

3. In the Format Data Series dialog box, enable Series Options in the left bar, select the Secondary Axis option, and close the dialog box.

4. Select the left vertical axis in the chart, then click Home> Font Color> White (or another color similar to the chart background).

Soure: Blebees.com

source https://blebees.com/add-two-sets-of-data-to-one-graph-in-excel/