+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Applying error bars to only some data points, not all

  1. #1
    Registered User
    Join Date
    09-18-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2007
    Posts
    4

    Applying error bars to only some data points, not all

    Now I've got a whole collection of values that I've applied error bars to, but unfortunately this makes the graph look very messy, how may I adjust the settings so that only a few values have error bars attached to it?

    This is what it looks like currently:

    http://imageshack.us/photo/my-images/200/21631157.jpg/

    That middle bit where it's sloping downwards looks a lot cleaner with those two error bars there, I'd ideally like the whole graph to look like that, nicely spaced out.

  2. #2
    Registered User
    Join Date
    09-18-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Applying error bars to only some data points, not all

    I clicked on a single point, went to Layout and under Current Selection it indicates that a single data point has been chosen, and then I go to error bars, custom, and it applies to everything. Not fun!

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

    Re: Applying error bars to only some data points, not all

    To apply different values to each point you need to use the Custom section.

    When you use the custom values you must supply a value for each point in the series. So if you only want to apply it to a single point the others must all have empty or zero values.

    An alternative maybe to add a series with only 1 data point but that would really depend on the chart type and data.
    Cheers
    Andy
    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