Pete ?!?

Anyway, with you chart that has 2 lines series add 2 more data series
based on exactly the same set of data. This will add 2 lines sitting on
to of the existing lines.
Select 1 of the new lines and change the chart type to area. Repeat for
2nd extra series. You should now have a shaded area below the top line.
Double click the area chart series and on the series order tab of the
format dialog reverse the order of the 2. You should now have a shade up
to the bottom line. Format both areas to have no border and the lower
area to have the same fill colour as the plot area.
If you want the lines to move away from the edges of the plot area
double click the x axis scale and on the scale tab check Value(Y) axis
crosses between categories.

Here is an example using the technique
http://www.andypope.info/ngs/ng21.htm

Cheers
Andy

Thorsten wrote:
Thorsten Wrote:

Hi,

I have an excel diagram showing two trend lines. One for the target and
one for actual. I would now like to shade the space between those lines
in order to highlight the B/W situation. Any idea how to do this?


Thanks for the answer Pete but I am still struggling a bit with this. I
attach an example of the database I meant.



Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Target heads 89 85 85 83 83 80 80 80 80 70 70 70
Actual heads 100 100 100 90 90 90 90 85 85 85 85 85





--

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