the title says it all - i have two columns of data in excel, let's call them a and b. i want to create a scatter plot with both the data in column a and the data in column b plotted on the vertical axis against row number plotted on the horizontal axis. excel wants to plot the data in col a on the vertical axis against the data in col b on the horizontal axis - or i can create two scatter plots col a vs. row number and col. b vs. row number (so it does understand the concept of data vs. row number at least). okay experts, how do i accomplish this simple task (other than export the data to a graphing package)? thanks.
Bookmarks