Thread: Combination charts

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

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.

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