How to Create a Two X Axis Chart in Excel

Written by matthew weeks
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Create a Two X Axis Chart in Excel
Charts with secondary axes can be created in minutes using Excel. (Jupiterimages/Comstock/Getty Images)

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

Instructions

  1. 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. 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. 3

    Click on "Format Selection" in the "Current Selection" section of the "Format" tab.

  4. 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. 5

    Click anywhere in the chart, then click the "Layout" tab in the top navigational menu. Click on "Axes".

  6. 6

    Click "Secondary Horizontal Axis" and then choose your desired layout from the display options. Your secondary plot will change to a horizontal one.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.