Cant make scatter plot from data

[sammgg]

so i have

x	y
1	2.72*10^(-7)
2	2.04*10^(-7)
3	1.51*10^(-7)
4	1.12*10^(-7)
5	7.9*10^(-8)
6	5.23*10^(-8)
7	3.21*10^(-8)
8	1.85*10^(-8)
9	9.74*10^(-9)
10	4.19*10^(-9)
11	1.10*10^(-9)
12	9.78*10^(-11)
13	1.88*10^(-12)
14	9.59*10^(-16)

<tbody>
</tbody>

for data and every time i try to make a scatter plot it just puts a chart with no points or data in it and i need this scatter plot for tomorrow but nothings working

 

[Cindy Ellis]

Hello sammgg, and welcome to Mr. Excel!
There are 2 easy ways to fix this...you get to choose whichever is easiest.
The data for "y" is entered as if it's a formula, except for the initial "=" sign. Also, the data implies that it's an attempt at scientific notation in Excel.
So...you can either enter an "=" before each entry in the "y" column, or you can change to Excel's scientific notation by replacing "*10^(" with the letter E, and deleting the ")" at the end.
For the first option, your first row would be =2.72*10^(-7) .
For the second option, your first row would be 2.72E-07. (If you just enter 2.72E-7, Excel will add the leading 0 on the -7).

Hope that helps,