Secondary axis.

[Guest]

I need to create a 2d bar graph with two different axis. I have used the
secondary axis in the format series option but can not get the bars to
display next to each other, they keep over lapping. In total i have 3 series
for each section, the bar on the secondary axis keeps overlapping between the
other two on the primary axis. Does anyone know how to stop this from
happening.

the primary axis is percentages and the secondary axis is a value.

 

[Andy Pope]

Hi,

See here for information on the way around the problem.
http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html

Cheers
Andy

 

[Del Cotter]

I need to create a 2d bar graph with two different axis. I have used the
secondary axis in the format series option but can not get the bars to
display next to each other, they keep over lapping. In total i have 3 series
for each section, the bar on the secondary axis keeps overlapping between the
other two on the primary axis. Does anyone know how to stop this from
happening.

The best way is to put a dummy series on each of the axes, one to hold a
place to the right of the bars that are to be left, and one on the other
axis to hold a place to the left of the bars that are to be right.

The two dummy series will be just full of nothing, but they'll push the
real bars apart for you and stop them overlapping with each other.

 

[Guest]

Here's some information from Microsoft that might be useful too:

http://support.microsoft.com/kb/214011/en-us