Double side-by-side bars and 2 y axis

G

Gwynne

I have a chart for requested by management that compares dollars spent to
time left to spend the balance. For example, How would I chart a total
dollar amount and the amount spent and on the same chart, chart the total
amount of time and time spent to date.

Total $s $s Spent Total Time Time Used
1,000,000 $500,000 340 days 65 days

Is there anyway Excel can do this? Right now I am creating 2 different
charts; bring them into CorelDraw and put the two together with 2 Y axises.

Any Help out there?

Thanks soooo much, Gwynne in Albuquerque
 
A

Alex

Gwynne,

I think the secondary axis feature will help. Chart the two variables you
want to compare as 2 series on the same chart. click on the series which you
want on the "second" y-axis which shall appear on right-side later... select
format data series > axis tab > radio button secondary axis

hope this helps!
 

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

how do I display 2 secondary Y axis' side by side? 4
Value (Y) axis crosses between categories and Secondary Value (Y) Axis 2
2 Bars and 2 Y Axis Chart 1
How do I display columns side-by-side in a two Y axis chart? 3
Thermometer chart with 2 Y axis? 3
Excel Chart with Horizontal bars left and right of y-axis (2 datasets) 1
How do I create a chart where there are two Y axis and the bars ar 2
Voici LE Moyen de Faire Beaucoup D'Argent Facilement !!!(TO SEE IT IN ENGLISH , JUST GO TO THE BOTTO 0

Top