multiple y axis scales?

Excel 2002

Can charts be created with multiple y axis scales and a common x-axis scale?

The VB Sub I have so far is this, but I would like to avoid Log Y axis and use a different scale for each series.

Please Login or Register  to view this content.

I've seen code that references xlPrimary. Is it possible to use xlSecondary to define a second Y axis? And if so, how does one associate a series with the secondary axis?

Please Login or Register  to view this content.

I'd like to graph say 4 series in a chart, 2 on one Y scale and 2 on another , but all using the same X scale. Does xlPrimary and xlSecondary help me do that?

Thanks,
ww