View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
John Mansfield John Mansfield is offline
external usenet poster
 
Posts: 235
Default Dynamic chart problem

In order to better understand what's happening, please post back with the
page on Jon's site that you are referring to.

-------
John Mansfield
http://www.cellmatrix.net


"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:$A I$10,1)
But with no luck, I get the following message "THAT FUNCTION IS NOT VALID"
Any ideas