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,