6 items line-column chart on 2 axis
 

I would like a bar chart to show (in 2 bars) the forecast dollars and actual
percentage, where the forecast $$ use the right axis and the actual % use the
left axis. The final 4 indicies will be charted using a line chart.

When I create this chart my bars stack instead displaying beside each other
presumable because each bar uses a different axis. Is there anyway to show
the bars in separate columns?

Thank you.

6 items line-column chart on 2 axis
 

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

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


"Bev" wrote in message
...
I would like a bar chart to show (in 2 bars) the forecast dollars and
actual
percentage, where the forecast $$ use the right axis and the actual % use
the
left axis. The final 4 indicies will be charted using a line chart.

When I create this chart my bars stack instead displaying beside each
other
presumable because each bar uses a different axis. Is there anyway to
show
the bars in separate columns?

Thank you.

6 items line-column chart on 2 axis
 

Thank you. I now see how this can be done by inserting dummy data. Too bad
the functionality dosen't make it easier.

I would like to say this discussion group format is great as I've learned a
few other tricks from reading some of the other Q &As.
cheers,

"Jon Peltier" wrote:

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

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


"Bev" wrote in message
...
I would like a bar chart to show (in 2 bars) the forecast dollars and
actual
percentage, where the forecast $$ use the right axis and the actual % use
the
left axis. The final 4 indicies will be charted using a line chart.

When I create this chart my bars stack instead displaying beside each
other
presumable because each bar uses a different axis. Is there anyway to
show
the bars in separate columns?

Thank you.