line chart error bars

[Genevieve]

Is there a way to have a shaded area in a line chart that would be in place
of error bars (and be shaded along the whole line) rather than say a 15%
error bar at every data point?

 

[Andy Pope]

Hi,

You can add 2 extra series plotted as stacked area. The first stack will
have no fill or border, this gives the effect of make the second area float.
The second area series is formatted with required shading.

The tough part is calculating the padding and actual value for the 2 series.

Cheers
Andy