Data Series with different axis scales

[mrmookster]

I have a line chart with two data series
1. range 0 - 70,000
2. range 0 - 500

I want to plot each against quarters, this is OK except the (auto) range selected is no use for the second series - how can i add multiple data ranges (axis scale) on the same axis?

CR10, XP, SQL Server

Thanks

 

[lbass]

After adding both summaries in the chart expert, right click on the chart->chart options->axes tab and select "dual axes"->"show 2 data axes".

-LB

 

[mrmookster]

The very dab! Thanks