Friday, April 20, 2012

How Do I Graph on a Secondary Axis in Excel Office Professional 2003?


1. Click on the data series on the chart that you want to plot on a secondary axis. For example, if you have a chart that shows price and volume and you want to display volume on a secondary axis, then click on 'volume.'
2. Click on 'Selected Data Series' on the Format menu.
3. Click on the 'Axis' tab, then click on 'Secondary axis.' Excel inserts a secondary axis into your worksheet.

Blogger news