Creating a chart with a secondary axis is not an uncommon task. Perhaps you wish to view how a change in one variable affects more than one other value. Less common, however, is the desire to measure how changes in more than one variable affect a single value. In either case, creating a chart with two X axes in Microsoft Excel is possible through the use of the options in the Chart Wizard.
- Skill level:
- Moderately Easy
Other People Are Reading
Create a chart that measures two data series against a set of variables using the Chart Wizard. Click "Finish" and the chart will appear in your worksheet.
Click anywhere on the chart. In the top navigational menu, click the "Format" tab. Click the arrow in the "Chart Elements" box, and then select the data series you wish to be the secondary plot.
Click on "Format Selection" in the "Current Selection" section of the "Format" tab.
Click on the "Series Options" tab in the pop-up window, and then select "Secondary Axis." Click "Close". You will see a secondary vertical axis appear in the chart.
Click anywhere in the chart, then click the "Layout" tab in the top navigational menu. Click on "Axes".
Click "Secondary Horizontal Axis" and then choose your desired layout from the display options. Your secondary plot will change to a horizontal one.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for