6 items line-column chart on 2 axis

G

Guest

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

Guest

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

Column Chart with 2 axes 7
Chart Issue - Excel 2003 2
Combination chart - Line - Column on 2 Axes 2
Display Horizontal and Vertical Line In Area Chart (Excel 2007) 2
Creating a Combination Bar Chart with 2 Lines 1
Combine Bar with Single Line Chart 5
can't click on series, close to Y-Axis 1
Stacked column chart narrow bars wanted 5

Top