Secondary axis.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...

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.
 
Back
Top