Combination charts

[kosciosco]

Hello,

Am having a slight problem with combination charts.

I have a list of people on the x axis and I want to present two different sets of data for each person as bar charts next door to each other. The problem I have is that one of the bars needs to represent a percentage and the other a number, so when I put the percentage on a secondary axis I get the two bars overlaying each other.

Any ideas how I get them side by side?

Thanks

K

[oldchippy]

May be this link can help?

http://peltiertech.com/Excel/Charts/ComboCharts.html

[kosciosco]

Thanks for that, unfortunately it doesn't quite work because changing one set of data onto a secondary axis throws the whole thing out if you want to use a bar chart for both sets.

[kosciosco]

Have found the answer to this now.

Because the chart always centres the data per axis, you have to create dummy figures which are zero, so in a chart with 2 bars, you need to create 4 sets of data.

Have a search on the website linked earlier in this thread and it is in there