MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Secondary axes

Posted by L on September 12, 2001 11:32 AM

I have 3 categories (columns) and 3 sets (rows) of data I need on a chart- 2 of the columns are in the hundred's and the third is in the 10's. Unfortunately when plotted you can't see the difference in values of these data in the 10's. I don't want to make a second chart. I want to add a secondary axis for these data in the values of 10's and plot these data next to the other sets.
Can anyone help me do this?

Posted by Eric on September 12, 2001 12:23 PM

While you have all of the data plotted, double click on the series you want to put on a secondary axis. The "Format Data Series" will come up. Select the axis tab and click the "plot series on" secondary axis radio button. Then say OK. If your values are too small to select at the automatic primary axis scale setting, go in and manually set the primary axis scale so that you can see and select the series. Then you can go back and readjust the primary and secondary axis ranges as you see fit.