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 Primary axis, you have the option of assigning your second data set to the secondary axis which makes your chart readable. Below you will find the instructions on how to do this, I used Excel 2003 for this demonstration, but it should hold true for 97-2007. If you have any questions or comments feel free to ask.

Before

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

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.

After

If you wish to view the step-by-step, click the pic tutorial icon below

Article posted on 01 24th, 2008

Related & Suggested Posts

1. How to Use Autofilters to Sort Data in Excel
2. How to Enable the Data Analysis ToolPak in Excel
3. Create Hierarchical Maps Like Those Used in ‘Smartmoney’s Map of the Market’
4. Sneak Peek: Access, Excel, PowerPoint, and Word 2010
5. Pin Frequently Used Documents and Save Time in Office 2007