Thanks for the confirmation. I figured out how to do it before I got your
post. FYI, this is how I did it also.
"Andy Pope" wrote:
Hi,
Have a look at this page.
http://peltiertech.com/Excel/Charts/...OnTwoAxes.html
Cheers
Andy
Patty wrote:
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?
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info