Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 12th 13, 11:50 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 22
Default Convert Error Bars to Series and Colour

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 a

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.

  #2   Report Post  
Old December 17th 13, 07:37 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 22
Default Convert Error Bars to Series and Colour

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



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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Different values for error bars in series wdwind1 Charts and Charting in Excel 1 April 6th 10 04:29 PM
How do I do different error bars within a series? Helen Charts and Charting in Excel 3 December 9th 08 07:52 PM
How to I incorporate SD from a data series into chart error bars? carlosPharm.D Charts and Charting in Excel 5 August 2nd 05 09:27 PM
How do I set different error bars per data point in a series Trebor1 Charts and Charting in Excel 2 June 3rd 05 01:08 PM
Error bars for a single data point not whole series Helen Charts and Charting in Excel 1 April 13th 05 06:21 PM


All times are GMT +1. The time now is 05:29 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017