Dynamic chart problem

[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

 

[John Mansfield]

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

 

[Tushar Mehta]

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

Regards,

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

 

[hoyos]

The page under excel charts then select Dynamic and Interactive Charts then
select Dynamic culumn Charts. Its the first exemple listed.

 

[Jon Peltier]

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

 

[hoyos]

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

 

[hoyos]

Sorry Jon it still giving me an error with "Series" highlighted in the formula

 

[hoyos]

Sorry Jon,
It still gives me a error message with "Series" highlighted in the formula

 

[hoyos]

Sorry Jon,
It still gives me a error message with "Series" highlighted in the formula

 

[Jon Peltier]

Make a chart with regular data and paste the series formula.

- Jon