[miked]

I would like to do a double "Y" axis bar chart for 2 variables with different
units against the same category (X variable). When I select "secondary Y" of
the second data series bars are then stacked rather than adjacent.

Thoughts?

Thanks, Mike

[Jon Peltier]

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

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


"miked" wrote in message
...
I would like to do a double "Y" axis bar chart for 2 variables with
different
units against the same category (X variable). When I select "secondary Y"
of
the second data series bars are then stacked rather than adjacent.

Thoughts?

Thanks, Mike

[ness]

Try switching it to columns, also go to custom charts in chart types scroll
down to "Lines and lines" or lines and bars and it will automatically set you
up for 2 data types with a second catagory y axis

"miked" wrote:

I would like to do a double "Y" axis bar chart for 2 variables with different
units against the same category (X variable). When I select "secondary Y" of
the second data series bars are then stacked rather than adjacent.

Thoughts?

Thanks, Mike