Hi,

This example might help,
http://www.andypope.info/ngs/ng21.htm

Cheers
Andy

rugby199993 wrote:
> I would like to have a LINE GRAPH comparing Revenue vs Expenses. When
> the Revenue >Expenses I want to shade the area Gray and when the
> Expenses >Revenue I want to shade the area RED. Any suggestions?
>
> Very simple example would be:
> FY05 FY06
> Revenue 100 200
> Expense 50 250
>
> Any help would be greatly appreciated!!
>
>

--

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