Want graph with 2 axis, but bars overlap when second axis added

[Guest]

I need to have a bar graph with two data sets of different scales, yet when I
change one data set to an secondary axis, the two bars combine. I need them
to be sitting side by side.

thanks

 

[Andy Pope]

Hi,

Here is one example.
http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

Cheers
Andy

 

[Jon Peltier]

Actually, this is more likely to be helpful:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Andy Pope]

Thanks Jon, I couldn't see that example for looking

 

[Jon Peltier]

Yeah, I need a better way to navigate through all of my examples. Maybe
I could adapt the ribbon-type user interface?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______