Double side-by-side bars and 2 y axis

  • Thread starter Thread starter Gwynne
  • Start date Start date
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
 
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!
 
Back
Top