Browse » Home
Thursday, March 14, 2013
How to Create a Two X Axis Chart in Excel
1. 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.
2. 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.
3. Click on 'Format Selection' in the 'Current Selection' section of the 'Format' tab.
4. 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.
5. Click anywhere in the chart, then click the 'Layout' tab in the top navigational menu. Click on 'Axes'.
6. Click 'Secondary Horizontal Axis' and then choose your desired layout from the display options. Your secondary plot will change to a horizontal one.