How to Plot a Secondary Axis on Microsoft Excelby Stephanie Ellen
Microsoft Excel isn't just for organizing and maintaining spreadsheets; Excel contains a powerful graphing component that can make dozens of different dynamic graphs that update automatically when your spreadsheet updates. If you have more than one data type in a graph (for example, volume and weight), you may want to plot the different data types on their own axes. Excel 2007 makes this process possible by allowing you to add a secondary axis to your chart.
Secondary Vertical Axis
Open the spreadsheet in Excel that contains the chart to which you want to add a secondary axis. Click the "Microsoft Office" button, then click "Open" and then locate the file on your computer. Click "Open" to open the file. Your existing chart should pop up on the screen when you open the spreadsheet. Depending on the type of graph you created, it could be a bar chart, line graph or other graph type.
Click the data series in the chart you want to plot on a secondary axis.
Click the "Format" tab, then click "Format Selection" in the "Current Selection" group.
Click the "Series Options" tab, then click "Secondary Axis" below "Plot Series On." The secondary axis will be display in the chart.
Secondary Horizontal Axis
Click anywhere on the chart to display Chart Tools.
Click the "Layout" tab, then click on "Axes" from the "Axes" group.
Click "Secondary Horizontal Axis," then click the type of display you want. For example, if you want an unlabeled axis, click "Show Axis Without Labeling."
- Distinguish the secondary axis from the primary axis by changing the chart type for a single data series. For example, display the first series as a line chart and the second series as a bar graph.
- You cannot make a secondary horizontal axis unless you have made a secondary vertical axis first.
Items you will need
- Existing Excel spreadsheet with a chart