shade below a trendline
 

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,

shade below a trendline
 

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" wrote:

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,

shade below a trendline
 

On Jan 30, 7:30*am, Dave Curtis
wrote:
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" wrote:
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,
I've done that, but management doesn't think that it's sufficient to
distinguish the meaning.

Thanks,

shade below a trendline
 

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


"Laoballer" wrote:

On Jan 30, 7:30 am, Dave Curtis
wrote:
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" wrote:
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,
I've done that, but management doesn't think that it's sufficient to
distinguish the meaning.

Thanks,

shade below a trendline
 

On Jan 30, 11:35*pm, Shane Devenshire
wrote:
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

"Laoballer" wrote:
On Jan 30, 7:30 am, Dave Curtis
wrote:
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" wrote:
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,
I've done that, but management doesn't think that it's sufficient to
distinguish the meaning.

Thanks,

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

shade below a trendline
 

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
"Laoballer" wrote in message
...
On Jan 30, 11:35 pm, Shane Devenshire
wrote:
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

"Laoballer" wrote:
On Jan 30, 7:30 am, Dave Curtis
wrote:
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" wrote:
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,
I've done that, but management doesn't think that it's sufficient to
distinguish the meaning.

Thanks,

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