shade below a trendline

[Laoballer]

has anyone generated a chart that shades below a linear trendline? I
would like to be able to do this so the viewer can easily distinguish
the meaning of data points.

thanks,

 

[Dave Curtis]

Hi,

I always find it really fiddly shading below a line.
Not quite sure why you need to distinguish the meaning of the data points,
but i usually add a couple of formulas so that I can have the points above
the trendline in one colour and the points below the trendline in another
colour.

Dave

 

[Laoballer]

Hi,

I always find it really fiddly shading below a line.
Not quite sure why you need to distinguish the meaning of the data points,
but i usually add a couple of formulas so that I can have the points above
the trendline in one colour and the points below the trendline in another
colour.

Dave

Dave,
I've done that, but management doesn't think that it's sufficient to
distinguish the meaning.

Thanks,

 

[Shane Devenshire]

Hi,

if you are using 2007 select the trendline and choose Chart Tools, Format
tab, and open the Shape Styles Gallery and pick a shadowed line near the
bottom.

In 2003 one option is to put two identical trendlines on the same series and
format one as a thick line and the other as a thin line. The thin one should
be in front. Format the thick one to one color and the thin one to another
color.

 

[Laoballer]

Hi,

if you are using 2007 select the trendline and choose Chart Tools, Format
tab, and open the Shape Styles Gallery and pick a shadowed line near the
bottom.

In 2003 one option is to put two identical trendlines on the same series and
format one as a thick line and the other as a thin line.  The thin one should
be in front.  Format the thick one to one color and the thin one to another
color.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire

I don't think I phrased the question correctly. What I want to do is
color the back ground of the chart that's below the trendline a
different color then the background above the trendline.

Thanks

 

[Andy Pope]

Hi,

Shading can be created using additional series plotted as an area chart.
What you need to do is create a set of data that is based on the trendline
formula.
See here for explanation on that.
http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Hi,

if you are using 2007 select the trendline and choose Chart Tools, Format
tab, and open the Shape Styles Gallery and pick a shadowed line near the
bottom.

In 2003 one option is to put two identical trendlines on the same series
and
format one as a thick line and the other as a thin line. The thin one
should
be in front. Format the thick one to one color and the thin one to another
color.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire

I don't think I phrased the question correctly. What I want to do is
color the back ground of the chart that's below the trendline a
different color then the background above the trendline.

Thanks