Chart with confidence intervals
Results 1 to 3 of 3

Thread: Chart with confidence intervals
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2015
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Chart with confidence intervals

    Hello all,

    Hoping you can help.

    I have created charts in excel before with 95% confidence intervals. What i cannot seem to work out though is how to create a horizontal chart with the confidence intervals/error bars.

    This link might not work when you click on it, but copying it and pasting it seems to do the trick. https://www.dropbox.com/home?preview=Capture.JPG

    Can anyone point me in the right direction.

    Rich
    Last edited by Rich2511; Oct 21st, 2016 at 10:57 AM.

  2. #2
    Board Regular Dr. Demento's Avatar
    Join Date
    Nov 2010
    Location
    Skipping stones off Charon's Ferry
    Posts
    541
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Chart with confidence intervals

    I can't download your file but have you seen these resources? Jon Peltier is the chart guru if there ever was one.

    Custom Error Bars in Excel Charts - Peltier Tech Blog

    I've never done it, but can't you create a vertical chart with error bars and then change chart type? Or is that merely wishful thinking??

    best wishes!!

  3. #3
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    4,609
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Chart with confidence intervals

    You need to right click on the file in Dropbox, click on Share, then click on Create a Link. Copy and paste this link into your post.
    Jon Peltier
    Peltier Technical Services, Inc.
    Try Peltier Tech Charts for Excel

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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