Check out the Index on Jon's site as there is a wealth of information on VBA
http://www.peltiertech.com/Excel/Cha...rtIndex.html#V

Basically you need to copy the appropriate chuck of code into a standard
code module.
To add a standard code module to your project,
Open the file
ALT+F11 - takes you to the Visual Basic Editor
Insert Module
Paste copied routine.

Now select a chart and then run the macro.
press ALT+F8 to display Macro dialog.
Select macro and Run.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"nobbyknownowt" wrote in message
...

Hello Andy
thanks for the quick reply
I would think that the fill polygon procedure will do me just fine but
would you have an idiots guide for how to carry out the procedure? I'm
pushing the limits of my knowledge with this!!
Just to add another variable. The data series I wish to fill is not
the only data series on the chart, would this cause problems.

cheers
Nobby (nice but dim)




--
nobbyknownowt