Convert Error Bars to Series and Colour

Discussion in 'Excel Charting' started by Spiggy Topes, Dec 12, 2013.

  1. Spiggy Topes

    Spiggy Topes Guest

    Tricky one, I think.

    I have a chart showing several series, using multiple overlaid areas and a couple of lines. One of the lines currently has error bars, but I want the user to be able to extract the values for those error bars using a VBA macro, and the DOM for Excel does not include access to error bar values. All other series just fine, error bars, no.

    So I'm thinking the only way to make this data available without specifically including a data sheet - it's a package of charts and it's big enough already - would be to turn the two error bars into two series and shade the intervening space, at 50% transparency so you can still see what's behind.

    Trouble is, I want to colour JUST the area between the series, and lay it on top of everything else. Tried just colouring the lower series at 100% transparency, didn't expect it would work, and it didn't.

    Any geniuses out there got a great solution to this? Or another way to handle?

    Just to elaborate, the plots are:

    Over the all time maximum (background colour)
    Between all time and ten year max
    Above 75th percentile (upper error bar)
    Mean
    Below 25th percentile (lower error bar)
    Between all time and ten year minumim
    Below ten year minimum

    So four coloured zones, plus the mean and two error bars on top.
     
    Spiggy Topes, Dec 12, 2013
    #1
    1. Advertisements

  2. Spiggy Topes

    Spiggy Topes Guest

    On Thursday, December 12, 2013 3:50:41 PM UTC-8, Spiggy Topes wrote:
    > Tricky one, I think.
    >
    >
    >
    > I have a chart showing several series, using multiple overlaid areas and a couple of lines. One of the lines currently has error bars, but I want the user to be able to extract the values for those error bars using a VBA macro, and the DOM for Excel does not include access to error bar values. Allother series just fine, error bars, no.
    >
    >
    >
    > So I'm thinking the only way to make this data available without specifically including a data sheet - it's a package of charts and it's big enough already - would be to turn the two error bars into two series and shade theintervening space, at 50% transparency so you can still see what's behind.
    >
    >
    >
    > Trouble is, I want to colour JUST the area between the series, and lay iton top of everything else. Tried just colouring the lower series at 100% transparency, didn't expect it would work, and it didn't.
    >
    >
    >
    > Any geniuses out there got a great solution to this? Or another way to handle?
    >
    >
    >
    > Just to elaborate, the plots are:
    >
    >
    >
    > Over the all time maximum (background colour)
    >
    > Between all time and ten year max
    >
    > Above 75th percentile (upper error bar)
    >
    > Mean
    >
    > Below 25th percentile (lower error bar)
    >
    > Between all time and ten year minumim
    >
    > Below ten year minimum
    >
    >
    >
    > So four coloured zones, plus the mean and two error bars on top.


    Guess that's a "no", huh? Well, I can't figure a way to get there. So I'll just add the two values as invisible series and that will have to suffice.

    Sad to see a group die like this...
     
    Spiggy Topes, Dec 17, 2013
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Joanna

    y-error bars on data points within a series

    Joanna, Jul 26, 2003, in forum: Excel Charting
    Replies:
    1
    Views:
    101
    Jon Peltier
    Jul 27, 2003
  2. Brian
    Replies:
    1
    Views:
    179
    Jon Peltier
    Jan 30, 2004
  3. JBR
    Replies:
    2
    Views:
    101
  4. rich zielinski via OfficeKB.com

    series graph -- one series being added to another series

    rich zielinski via OfficeKB.com, Mar 28, 2005, in forum: Excel Charting
    Replies:
    3
    Views:
    260
    rich zielinski via OfficeKB.com
    Mar 30, 2005
  5. Trebor1
    Replies:
    2
    Views:
    89
    Jon Peltier
    Jun 3, 2005
  6. carlosPharm.D
    Replies:
    5
    Views:
    106
    Jon Peltier
    Aug 2, 2005
  7. dothareggae
    Replies:
    1
    Views:
    81
    Andy Pope
    Jul 19, 2005
  8. Millie
    Replies:
    2
    Views:
    253
    Jon Peltier
    Apr 25, 2009
Loading...