How to Create a Two X Axis Chart in Excel


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.

  • 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.

Related Searches


  • Photo Credit Jupiterimages/Comstock/Getty Images
Promoted By Zergnet


You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!