# Need help with Excel

1. Sep 22, 2008

### magma_saber

1. The problem statement, all variables and given/known data
Not sure if this is suppose to be posted here or not, but i need help with making a chart in excel 2007. I need to make a scatter chart.
The x value is 0.25.
The y values are 4.68E-19, 4.10E-19, 3.06E-19.

3. The attempt at a solution
I tried making the chart but it gets all messed up and i get all confused. Any help would be great.

2. Sep 22, 2008

### Redbelly98

Staff Emeritus
I'm able to make an Excel scatter chart with those numbers. I put the numbers into two columns and three rows like this:

0.25 | 4.68e-29
---------------
0.25 | 4.10e-29
---------------
0.25 | 3.06e-29

Can you describe in what way is the chart messed up?

3. Sep 22, 2008

### magma_saber

4. Sep 22, 2008

### Redbelly98

Staff Emeritus
Okay, I think I can help with that.

Double-click on the y-axis of the chart. The "Format Axis" window should pop up.
Click the "Scale" tab in the Format Axis window.

I'm guessing the problem is either of two things:
1. The boxes under "Auto" are not checked. Check them all, then click "Okay"
or
2. The boxes under "Auto" are checked, but Excel has a problem auto-formatting with these small numbers. Enter the following numbers instead:
Minimum: 0
Maximum: 5e-29
Major Unit: 1e-29
Make sure the Auto boxes are checked for Minor Unit and for Value Axis Crosses At.
Click "Okay"

That should fix the problem. Go ahead and change the axis Maximum, Minimum, and Major Unit as you see fit.

If there are still problems, repost here and I'll think about it some more.

Good luck.

5. Sep 23, 2008

### Staff: Mentor

I don't get it. All x coordinates are identical, so what kind of plot do you expect?

6. Sep 23, 2008

### Redbelly98

Staff Emeritus
I thought the problem was no numbers displayed along the y-axis (except for the zero). If the problem is something else, magma_saber will have to clarify.

7. Sep 23, 2008

### magma_saber

8. Sep 23, 2008

### stewartcs

A scatter chart. The pairs would be in a vertical column similar to this:

Code (Text):

*

x

+

CS

9. Sep 23, 2008

### Staff: Mentor

As far as I remember that's how it looked alike, imageshack is down so I can't check. But new picture posted by OP is just like that - three points in the vertical line. So it looks correct - so I don't understand where the problem is.

Last edited: Sep 23, 2008
10. Sep 23, 2008

### stewartcs

Oh, now I get your point!

I didn't know he had a picture posted the first time (I can't see them while I'm at work).

CS

11. Sep 23, 2008

### Redbelly98

Staff Emeritus
12. Sep 23, 2008

### Redbelly98

Staff Emeritus
I got a decent chart using these y-axis settings:

13. Sep 24, 2008

### magma_saber

i finally got it to work. for some reason i can't get it to work with excel 2007. luckily office 2007 comes with the older version of office, so i got it to work with excel 2003.