+ Reply to Thread
Results 1 to 2 of 2

Thread: Error bars

  1. #1
    Registered User
    Join Date
    06-27-2009
    Location
    Israel
    MS-Off Ver
    Excel 2007
    Posts
    2

    Question Error bars

    Hi
    I have excel 2007
    I need to insert error bars (based on STDEV data I have) in a bar chart. somehow, it wont enable me to change error bar within the series. it changes all error bars in the series simultaniously and not specificaly. how can I change a specific error bar if it is part of a series?
    thank you very much

    Orit

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,943

    Re: Error bars

    You need to set the range via the Custom button.
    You will need a cell for each data point in the series even if the cell is blank.

    If still stuck post example file.
    Cheers
    Andy
    www.andypope.info

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