Don't know what page on Jon's site you are referring to but you may
also want to check
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

On Wed, 7 Oct 2009 17:01:01 -0700, hoyos
wrote:

I am following the example from 'Peltier' site.
All goes well until I get to changing the chart's data source.
It tells me to insert the following formula:
=Series(Data!$AI$1,Data!$AH$2:$AH$10,Data!$AI$2:$ AI$10,1)
But with no luck, I get the following message "THAT FUNCTION IS NOT VALID"
Any ideas
Regards,

Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins