See More About: , ,

How to Add A Second Axis to Your Charts in Excel

by

excelscreen How to Add A Second Axis to Your Charts in Excel

When using Excel and working with two data sets that differ greatly in range it can be difficult to chart those values due to the larger range of one of your data sets. A classic example of this would be your monthly data and your YTD values for each month. When you put these together in a chart the monthly data is diminished by the much larger YTD values. In order to overcome this you can assign each data set an axis.

The default for all your data sets is the Primary axis, you have the option of assigning your second data set to the second axis which makes your chart readable. Below you will find the instructions on how to add a second axis to an Excel graph.

If you have any comments or questions, please post them below.

Note: I used Excel 2003 for this demonstration, but it should hold true for 97-2007.

Graph without Second Axis

excelbef How to Add A Second Axis to Your Charts in Excel

The following steps were written assuming you have a chart in excel with more than one data set.


If you wish to view the step-by-step, click the pic tutorial icon ->pictuticon How to Add A Second Axis to Your Charts in Excel or you can follow the steps below.

1. Select a point on the graph for the data set you want to put on the secondary axis.

2. Right-click and select Format Data Series…

3. Click on the Axis tab and select the Secondary axis radio button

4. Click OK

5. Your selected data set should now reside on the second axis of your chart.

Graph with Second Axis Enabled

excelaf How to Add A Second Axis to Your Charts in Excel

See More About: , ,
Originally posted Jan 24, 2008

We close comments after 30 days on GilsMethod.com and ask that you post questions and issues on our Answers website.

This helps us better serve you by allowing us to keep track of unanswered questions that are usually hidden in long comment threads.

Answers.GilsMethod.com is a community-powered support website where you will be able to post questions, and other users including us will respond with expert advice.

So if you are having trouble with your PC, Mac, iPad, iPhone, or other piece of technology, head over to Answers.GilsMethod.com and ask away.

  • http://www.gilsmethod.com Gilberto J Perera

    Diane,

    Glad you found the article useful and thanks for sharing.