+ Reply to Thread
Results 1 to 7 of 7

Error bars in chart

  1. #1
    Registered User
    Join Date
    01-17-2010
    Location
    Vilnius
    MS-Off Ver
    Excel 2007
    Posts
    4

    Error bars in chart

    Hi,

    I have a problem. I have a graph and I need to cut it in to three parts. The part in the left must be without any net(white colour), the bigger right side must have a mild coloured net, and the smallest darker net.

    In first attachement you can see what I want in my graph.
    The second attachement is the graph on which I want that you put error bar.

    Thank you
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Error bars in chart

    this is not an easy feat. Maybe this will help:

    http://peltiertech.com/Excel/Charts/XYAreaChart.html

  3. #3
    Registered User
    Join Date
    01-17-2010
    Location
    Vilnius
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Error bars in chart

    I have no idea how to do that. Maybe there is somebody who can made it? I would be very happy

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Error bars in chart

    Just add another data series and plot as area chart.
    Then add Vertical error bars 100%. Increase the error bar thickness to fill the area,
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  5. #5
    Registered User
    Join Date
    01-17-2010
    Location
    Vilnius
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Error bars in chart

    Can you put the darker in the right side one please? Cause I don't get how exacly do it... Thanks a lot!

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Error bars in chart

    You just need to add another series with data for the valid x values.
    Add vertical error bars as detailed before.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    01-17-2010
    Location
    Vilnius
    MS-Off Ver
    Excel 2007
    Posts
    4

    Thumbs up Re: Error bars in chart

    Thank you a lot! ! !

+ 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