excel charting

Tags: Windows, Software
0 Votes

excel charting

i have an excel 97-2003 spreadsheet and we changed to excel 2007 for some reason.

for a chart, i have two columns, A and B. i want column A to be the "Y" axis and column B to be the "X" axis. when i try and create a chart in the 97-2003 spreadsheet, both columns are plotted on the "Y" axis and the "X" axis is the number of data points.

is it because i have a 97-2003 spreadsheet using 2007?

i have attempted to use "save as" to save the file to excel 2007 but i don't have that option when "save as" pops up.

any ideas on what's happening.

Member Answers