View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Thorsten Thorsten is offline
external usenet poster
 
Posts: 1
Default How to fill or shade space between to trend lines?


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




--
Thorsten