Excel hotshots: Help! Chart question

Discussion in 'OT Technology' started by Joe_Cool, Dec 30, 2004.

  1. Joe_Cool

    Joe_Cool Never trust a woman or a government. Moderator

    Joined:
    Jun 30, 2003
    Messages:
    299,200
    Likes Received:
    510
    I want to graph some data in excel. What I have is a number of data points, each with a margin of error. What I want is an xy scatter plot, with vertical whiskers on each point to represent the margin of error. Is there a way to do what I need?

    Final product should look something like this (the trendline is irrelevant - it should be available, but is beside the point):

    [​IMG]
     
  2. Joe_Cool

    Joe_Cool Never trust a woman or a government. Moderator

    Joined:
    Jun 30, 2003
    Messages:
    299,200
    Likes Received:
    510
  3. Joe_Cool

    Joe_Cool Never trust a woman or a government. Moderator

    Joined:
    Jun 30, 2003
    Messages:
    299,200
    Likes Received:
    510
    Last try.
     
  4. cakennedy

    cakennedy Guest

    Sure. Just use the Stock: High-Low-Close chart. This chart requires those three columns in that order; to convert from value/margin of error, just multiply value * (1+MOE) and (1-MOE), for high and low. You can, of course, format the chart however you want.

    [​IMG]
     
  5. Joe_Cool

    Joe_Cool Never trust a woman or a government. Moderator

    Joined:
    Jun 30, 2003
    Messages:
    299,200
    Likes Received:
    510
    Awesome. Thanks. :)
     

Share This Page