Dynamic chart problem

  • Thread starter Thread starter hoyos
  • Start date Start date
H

hoyos

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
 
In order to better understand what's happening, please post back with the
page on Jon's site that you are referring to.
 
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/newsgroups/dynamic_charts/index.html

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
Click to expand...
Regards,

Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins
 
The page under excel charts then select Dynamic and Interactive Charts then
select Dynamic culumn Charts. Its the first exemple listed.
 
Wild guess: some localized versions of Excel require arguments in
functions to be separated by semicolons instead of commas:

=Series(Data!$AI$1;Data!$AH$2:$AH$10;Data!$AI$2:$AI$10;1)

- Jon
 
Sorry Jon, Still get the same problem.
Same error message with "Series" highlighted in the formula.
 
Back
Top