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.