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 |
#11
|
|||
|
|||
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 |
|
Thread Tools | |
Display Modes | |
|
|