| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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
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
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
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
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
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
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 |
|
#11
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Dynamic chart problem
Make a chart with regular data and paste the series formula.
- Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ hoyos wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic chart problem | Excel Discussion (Misc queries) | |||
| Dynamic chart pasted to a new workbook in report can't be dynamic | Charts and Charting in Excel | |||
| Dynamic chart - series label problem | Charts and Charting in Excel | |||
| problem with dynamic data in chart? | Charts and Charting in Excel | |||
| Dynamic Bar Chart Category Axis Problem | Charts and Charting in Excel | |||
Linear Mode
