Combination Chart
 

In Excel 95 you could create a chart with two different Y-axis by creating a
Combination chart type.

How can you do the same thing with current version of Excel.

Combination Chart
 

If you have 2 lines say on a chart, you can place one on another Y axis
by right clicking on that line selecting format data series and going
to the axis tab. Select secondary axis and click ok.


--
PowerWheels
------------------------------------------------------------------------
PowerWheels's Profile: http://www.excelforum.com/member.php...o&userid=30045
View this thread: http://www.excelforum.com/showthread...hreadid=497782

Combination Chart
 

If you have 2 lines say on a chart, you can place one on another Y axis
by right clicking on that line selecting format data series and going
to the axis tab. Select secondary axis and click ok.


--
PowerWheels
------------------------------------------------------------------------
PowerWheels's Profile: http://www.excelforum.com/member.php...o&userid=30045
View this thread: http://www.excelforum.com/showthread...hreadid=497782

Combination Chart
 

If you have 2 lines say on a chart, you can place one on another Y axis
by right clicking on that line selecting format data series and going
to the axis tab. Select secondary axis and click ok.


--
PowerWheels
------------------------------------------------------------------------
PowerWheels's Profile: http://www.excelforum.com/member.php...o&userid=30045
View this thread: http://www.excelforum.com/showthread...hreadid=497782