|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#1
October 8th, 2009, 01:01 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic chart problem
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 
|
|
#2
October 8th, 2009, 08:02 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
|
|
#3
October 8th, 2009, 08:04 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Dynamic chart problem
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" wrote in message ... 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
|
|
#4
October 9th, 2009, 06:35 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Dynamic chart problem
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
|
|
#5
October 10th, 2009, 11:28 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Dynamic chart problem
The page under excel charts then select Dynamic and Interactive Charts then
select Dynamic culumn Charts. Its the first exemple listed. "Tushar Mehta" wrote: 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
|
|
#6
October 10th, 2009, 08:24 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Dynamic chart problem
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:$A I$10;1) - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ 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
|
|
#7
October 15th, 2009, 04:26 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Dynamic chart problem
Sorry Jon, Still get the same problem.
Same error message with "Series" highlighted in the formula. "Jon Peltier" wrote: 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:$A I$10;1) - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ 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
|
|
#8
October 15th, 2009, 04:29 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Dynamic chart problem
Sorry Jon it still giving me an error with "Series" highlighted in the formula
"Jon Peltier" wrote: 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:$A I$10;1) - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ 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
|
|
#9
October 15th, 2009, 04:30 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Dynamic chart problem
Sorry Jon,
It still gives me a error message with "Series" highlighted in the formula "Jon Peltier" wrote: 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:$A I$10;1) - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ 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
|
|
#10
October 15th, 2009, 04:49 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Dynamic chart problem
Sorry Jon,
It still gives me a error message with "Series" highlighted in the formula "Jon Peltier" wrote: 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:$A I$10;1) - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ 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
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
