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