Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Dynamic chart problem

2 views
Skip to first unread message

hoyos

unread,
Oct 7, 2009, 8:01:01 PM10/7/09
to
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

David Biddulph

unread,
Oct 8, 2009, 3:04:26 AM10/8/09
to
My guess is that you've tried to insert that formula into a worksheet
instead of into a chart.
In the chart you need to select the series you are wanting to edit.
--
David Biddulph

"hoyos" <ho...@discussions.microsoft.com> wrote in message
news:B5CAE784-347C-4D2A...@microsoft.com...

John Mansfield

unread,
Oct 8, 2009, 3:02:02 AM10/8/09
to
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

Tushar Mehta

unread,
Oct 9, 2009, 1:35:30 AM10/9/09
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

Regards,

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

hoyos

unread,
Oct 10, 2009, 6:28:02 AM10/10/09
to
The page under excel charts then select Dynamic and Interactive Charts then
select Dynamic culumn Charts. Its the first exemple listed.

Jon Peltier

unread,
Oct 10, 2009, 3:24:13 PM10/10/09
to
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
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/

hoyos

unread,
Oct 15, 2009, 11:26:12 AM10/15/09
to
Sorry Jon, Still get the same problem.
Same error message with "Series" highlighted in the formula.

hoyos

unread,
Oct 15, 2009, 11:30:37 AM10/15/09
to
Sorry Jon,
It still gives me a error message with "Series" highlighted in the formula

hoyos

unread,
Oct 15, 2009, 11:29:29 AM10/15/09
to
Sorry Jon it still giving me an error with "Series" highlighted in the formula

hoyos

unread,
Oct 15, 2009, 11:49:55 AM10/15/09
to
Sorry Jon,
It still gives me a error message with "Series" highlighted in the formula

Jon Peltier

unread,
Oct 16, 2009, 9:05:39 PM10/16/09
to
Make a chart with regular data and paste the series formula.
0 new messages