How to Make a Combo Chart with Two Y Axis in Excel 2010

If you have Excel 2010 and you are making a combo chart with 2 Y-Axis, please follow the steps below. Excel 2016 has made this much easier, if you are working with Excel 2016, please refer here for details.

Step 1: Suppose we are making a chart with the data in the Table below, and we want to combine the number of "Met" in column B and "% of Met" in column C together;

Step 2: Highlight the data in the data range A1:C6. In the "Insert" Tab from the Ribbon, click "Column", then select "Clustered Column".

Step 3: A combo chart will be created. The percentage columns are short and we need to change them to a line chart.

Step 4: To change Columns to Line chart: Right click on the short columns, and select "Change Series Chart Type" from the dialog box;

Step 5: In the "Change Chart Type" window, select Column on the left navigation bar, then select "Line with Markers".

Step 6: Now the combo chart should like the one below, the line chart is low and only have one Y Axis on the left.

Step 7: To make a secondary Y-Axis for the line chart (%): right click on the line chart, and select "Format Data Series";

Step 8: In the "Format Data Series" window, check "Secondary Axis" from the Series Options section;

Step 9: A combo chart with two Y-Axis is created. You can change the color, Axis value or any other elements to make it better.

Download Example

Leave a Reply