6 items line-column chart on 2 axis

B

Bev

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.
 
B

Bev

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sideways stacked bar charts with line series on the same axis 0
Column Chart with 2 axes 7
Chart Issue - Excel 2003 2
Display Horizontal and Vertical Line In Area Chart (Excel 2007) 1
In a Line-column graph on 2 axes, how do I stack the columns? 1
Line Chart - Problems with labeling X-Axis 3
Stacked column chart narrow bars wanted 5
Labeling on independently stacked line chart 0

Top