MrExcel.com - Your One Stop for Excel Tips & Solutions

Secondary axis

Posted by Judi Helgeson on March 08, 2000 10:35 AM

How do I set up a secondary axis on a chart

Posted by Jaime on March 08, 2000 10:58 AM

Hi, In the chart wozard go to Custom Types.

I there there are several charts that have 2 AXES.

Posted by John Brehm on March 08, 2000 12:43 PM

If you already have your data in a chart, right click on the data series you want charted on a secondary axis and select Format Data Series, then the axis tab. Click the Plot seiries on Secondary axis radio button. A secondary axis will be automatically added and auto-scaled for the data series selected.