Creating a Scatter Chart in Excel 2007

[magma_saber]

Homework Statement

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.

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.

 

[Redbelly98]

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?

 

[magma_saber]

When i try making it, this shows up:
http://img248.imageshack.us/my.php?image=capturevx4.jpg

 

[Redbelly98]

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.

 

[Borek]

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

 

[Redbelly98]

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.

 

[magma_saber]

this is what i get when i followed your instructions:
http://img129.imageshack.us/my.php?image=capturewa4.jpg

 

[stewartcs]

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

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

     *

     x




     +

CS

 

[Borek]

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.

 

[stewartcs]

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.

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

 

[Redbelly98]

this is what i get when i followed your instructions:
http://img129.imageshack.us/my.php?image=capturewa4.jpg

Can you post a screen shot of the y-axis Scale settings?

 

[Redbelly98]

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

 

[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.