I have three columns of data, and I want to put them into a chart. The first two columns are numbers, and the third column is percentages. I want to plot the third column on a second X-axis. I used to be able to do this in Excel 2003, but for the life of me I can’t figure out how to get this done in Excel 2007. Can anyone lend a hand? Thanks.
If you right click on the line drawn for the third data series the option for graphing on the primary or secondary axis pops up.