+ Reply to Thread
Results 1 to 2 of 2

Individual Error Bars

  1. #1
    Jerry
    Guest

    Individual Error Bars

    I know how to set the error bars on a standard line graph. Unfortunately when
    I set it the error bars appear the same at every plot. On the data I have the
    points have varying error ranges. My question is, how can I set different
    error bars for each individual point?

  2. #2
    Andy Pope
    Guest

    Re: Individual Error Bars

    Hi,

    Use the Custom +/- values, which allows you to use values from cells.
    See Jon's explanation of error bars.
    http://peltiertech.com/Excel/ChartsHowTo/ErrorBars.html

    Cheers
    Andy

    Jerry wrote:
    > I know how to set the error bars on a standard line graph. Unfortunately when
    > I set it the error bars appear the same at every plot. On the data I have the
    > points have varying error ranges. My question is, how can I set different
    > error bars for each individual point?


    --

    Andy Pope, Microsoft MVP - Excel
    http://www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1