Tuesday, December 24, 2013

How to Have Three Secondary Axes on Excel 2007


1. Open the chart you want to work with by clicking the Office button, 'Open,' and selecting the file.
2. Click the chart you want to add the additional axes to. This brings up the 'Chart Tools' tab in the top right corner of Excel.
3. Click the 'Format' tab. Select the arrow under 'Chart Area' (in the 'Current Selection' group on the left side of the toolbar). This brings down a selection box. Choose the series you want to add an additional axis to.
4. Click 'Format Selection.' Format Selection is directly below the 'Chart Area' tab.
5. From the 'Series Options' tab (this should be the first one displayed), click 'Secondary Axis' and then click the 'Close' button.
6. Click the 'Layout' tab and choose 'Axes' from within the Axes group. Click on 'Secondary Vertical Axis' and choose a display option.
7. Repeat Steps 2 to 6 to add another axis.

Blogger news