How to Create a Four Axis Chart in Excel 2007

Add a Secondary Vertical Axis
1. In a chart, select the data series you want to put on a second vertical axis. Either select the data series from the chart itself or select it from a list in 'Chart Tools.' To select it from a list, click the chart. In 'Chart Tools,' click the 'Format' tab. In the 'Current Selection' group, click the arrow in 'Chart Elements.' Select the data series to which you want to add a secondary vertical axis.
2. On the 'Format' tab, in the 'Current Selection' group, select 'Format Selection.' The 'Format Data Series' box will display.
3. On the 'Series Options' tab, under 'Plot Series On,' select 'Secondary Axis.' Click 'Close.' The new axis will display in the chart.
4. On the 'Layout' tab in 'Chart Tools,' in the 'Axes' group, click 'Axes.' Click 'Secondary Vertical Axis' to change the display options for the axis. To change the axis options, right click the secondary axis and select 'Format Axis.' Make options changes under 'Axis Options.'
5. Repeat these steps for each data series to which you want to add a secondary vertical axis.
Add a Secondary Horizontal Axis
6. Click the chart that displays a secondary vertical axis. You cannot display a secondary horizontal axis without a secondary vertical axis.
7. On the 'Layout' tab in 'Chart Tools,' in the 'Axes' group, select 'Axes.'
8. Click 'Secondary Horizontal Axis.' Make changes to the display options that you want.