How to Make a Combo Chart with Two Bars and One Line

Suppose we have the number of persons and percentage who met the criteria in each region, and the total persons who participated. We need to make a combo chart to include all these 3 fields.

Step 1: Select the data in the data range;

Step 2: Click the "Insert" Tab from the Ribbon;

Step 3: Click "Insert Combo Chart" in the "Charts" section;

Step 4: Click Clustered Column - Line on Secondary Axis;

Step 5: You will see the new combo chart now is ready;

Step 6: To change Y-Axis ("Met" or "% of Met"), double click on the Y-Axis, and change the value in the Format Axis window;

Step 7: To change Chart Tile, double click and change the words in the title box.

Download Example

Leave a Reply