Excel 2010 | Add Secondary Chart Axes

With the addition of a secondary axis, Excel allow you easily compare data.

Adding a Secondary Y-Axis

secondary axis

  1. Click the chart.
  2. Click on the data series that will become the secondary axis.
  3. On the Chart Tools Format tab, in the Current Selection group, click the Format Selection button.
  4. In the Format Data Series dialog box, in the Plot Series On section, choose the Secondary Axis radio button.
  5. Click the Close button.

Change Chart Type

change chart type

  1. On the Chart Tools Design tab, in the Type group, click the Change Chart Type button.
  2. In the Change Chart Type dialog box, click the appropriate chart type.
  3. Click the OK button.

Adding a Secondary Y-Axis


    1. On the Chart Tools Layout tab, in the Axes group, click the Axes button.
    2. In the Axes drop down list, hover over Secondary Horizontal Axis or Secondary Vertical Axis.
    3. Make a choice from the appropriate drop down list.
Note: If your target Axis is not on the drop down list, choose More Options.
__________________________________________________________________________________________________ In an effort to provide desktop support to each user, Solo’s proprietary product Datumms™ is designed to provide targeted training and support at the users’ desktop that reinforces and accelerates end user adoption of Microsoft® Office applications.  Datumms™ supports a blended method of learning and can be used as a single source for training or complement instructor-led and on-line classes, trainers, Help Desks and Educators.   With Datumms™, there is no need to flip through page after page of manuals, search the internet for answers or repeatedly contact the help desk with questions.  For one low subscription rate to an annual license, everyone within your organization can utilize Datumms™ without the need to manage individual logins and licenses.  With an active license, all end users with network access may utilize the complete printable library of quick reference cards and view the e-learning video demonstrations with unlimited 24/7 access. Let us help you with Excel 2010 video guides! Datumms logo
Learn More

Become an Excel 2010 Expert!

Already have the basics down? It’s time to take Microsoft Excel to the next level. Learn how to get the right information to the right people at the right time, utilizing these features:

  • Manipulate data using advanced formulas.
  • Analyze data with logical and lookup functions.
  • Organize data with Data Commands.
  • Make use of Macros and Shapes.
  • Analyze data with PivotTables.


Article Name
How to Add Secondary Chart Axis
Learn How To Add a Secondary Chart Axis in Excel 2010
Publisher Name
Executrain of Houston
Publisher Logo


Thank you! One of our advisors will contact you shortly.