Pareto Chart

[Cessh]

Dear fellow excelforum

I have created a pareto chart in excel 2013 using the "clustered bar" as the chart type for series 1 (which is vertical orientation and also where the main data lies) and "line with markers" as the chart type for the series 2 (where the percentage lies). The problem i'm facing is that when i select "column" as the chart type for series 1 it seems to fit proportionaly to the series 2 in horizontal orientation. But when i selected "clustered bar" as the chart type for series 1 it seems to be not in line or out of proportion with series 2 chart (the file is attached). Because series 2 seems to be in the horizontal orientation while series 1 is in the vertical orientation.

I was wondering how to make the horizontal chart type "line with markers" to become vertical so that it could be in line with the vertical type chart "clustered bar" in one chart?

[MrShorty]

I was wondering how to make the horizontal chart type "line with markers" to become vertical so that it could be in line with the vertical type chart "clustered bar" in one chart?

I think the answer to this question is to use a bar+XY scatter combination chart, rather than a line chart. See tutorial: http://peltiertech.com/Excel/Charts/BarLineCombo.html