1. Not finding help here? Sign up for a free 30min tutor trial with Chegg Tutors
    Dismiss Notice
Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Need help with Excel

  1. Sep 22, 2008 #1
    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. jcsd
  3. Sep 22, 2008 #2

    Redbelly98

    User Avatar
    Staff Emeritus
    Science Advisor
    Homework Helper

    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?
     
  4. Sep 22, 2008 #3
  5. Sep 22, 2008 #4

    Redbelly98

    User Avatar
    Staff Emeritus
    Science Advisor
    Homework Helper

    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.
     
  6. Sep 23, 2008 #5

    Borek

    User Avatar

    Staff: Mentor

    I don't get it. All x coordinates are identical, so what kind of plot do you expect?
     
  7. Sep 23, 2008 #6

    Redbelly98

    User Avatar
    Staff Emeritus
    Science Advisor
    Homework Helper

    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.
     
  8. Sep 23, 2008 #7
  9. Sep 23, 2008 #8

    stewartcs

    User Avatar
    Science Advisor

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

    Code (Text):


         *

         x




         +

     
    CS
     
  10. Sep 23, 2008 #9

    Borek

    User Avatar

    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
  11. Sep 23, 2008 #10

    stewartcs

    User Avatar
    Science Advisor

    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
     
  12. Sep 23, 2008 #11

    Redbelly98

    User Avatar
    Staff Emeritus
    Science Advisor
    Homework Helper

  13. Sep 23, 2008 #12

    Redbelly98

    User Avatar
    Staff Emeritus
    Science Advisor
    Homework Helper

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

    [​IMG]
     
  14. Sep 24, 2008 #13
    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.
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Have something to add?



Similar Discussions: Need help with Excel
  1. Help with using Excel (Replies: 6)

  2. Help needed (Replies: 6)

  3. Need help (Replies: 5)

Loading...