Alternate Y axis in bar charts

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

Guest

I have a bar chart with 2 data series on it. I want to use separate y axes
for each, but the bars keep appearing on top of eachother, no matter what I
try. I want one set of bars to use the left hand Y axis and the other set of
bars to use the axis on the right side. 2-D bar charts apparently don't do
this. Is there a way to perform this function?
 
Patty:
Make series A two times so they appear besides each other. Hide the left of
the two, by making all attributes (line/fill) none. Effectively u see now
all bars in one fold, but right of the centre. Repeat for series B, but hide
the right one. Now the bars appear side by side.
HTH,
Henk
 
Thanks for the confirmation. I figured out how to do it before I got your
post. FYI, this is how I did it also.
 
Back
Top