How do I create a chart where there are two Y axis and the bars ar
 

How do I create a chart where there are two Y axis and the bars are side by
side. I created one and used overlapping, but it puts the bars on top of
each other as opposed to side by side...

the simplest solution is to actually plot 4 series 2 for each axis
set the data in the first for one axis to zero and the data for the second
to zero for the other axis.

"Dan" wrote:

How do I create a chart where there are two Y axis and the bars are side by
side. I created one and used overlapping, but it puts the bars on top of
each other as opposed to side by side...

This web page illustrates bj's suggestion:

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

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


bj wrote:

the simplest solution is to actually plot 4 series 2 for each axis
set the data in the first for one axis to zero and the data for the second
to zero for the other axis.

"Dan" wrote:


How do I create a chart where there are two Y axis and the bars are side by
side. I created one and used overlapping, but it puts the bars on top of
each other as opposed to side by side...