multiple scale bars

[VBA]

Heya,

I googled around and used the excel help-function, but I must be using the wrong terms for I found nothing on this subject

I would like to put different data in one and the same graph. For example, I'm graphing costs against mont AND working hours. The costs are way, way more (in millions) than the working hours (in thousands).
With only one y-scale bar (left) such a graph might give you insight in the costs, but makes the differences in working hours unreadable as they're so low on the chart and seem to be at the same height all the time.

Is it possible in excel to have an y-scale (left) for series 1, and an y-scale (right) for series 2?

Or should I just make 2 transparent graphs and place them on top of one another?

Thanks in advance

 

[Richard Schollar]

Hi

With your two data series in the chart, right click on just one of the series and choose Format Data Series. On the axis tab you can choose to have it displayed on a secondary Y axis.

 

[VBA]

Ow, dang! I only checked that property thrice

Thank you so much!

 

[ff_emt1]

I have done several searches, but this is the closest I have found to my problem.

Any suggestion on how to do this in Excel 2000 (sorry, corporate environment and they will not upgrade)? I have a Format Data Series tab, but no "displayed on a secondary Y axis" option.

Thanks