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
|
|||
|
|||
Dynamic chart problem (re-posted)
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" with "SERIES" highlighted? Any ideas |
#2
|
|||
|
|||
Dynamic chart problem (re-posted)
I had to re-post this question due to problems with my computer, which are
sorted now.......hopefully!!! Previous help from Jon Peltier and others were very much appreciated but unfortunately did not work. I would be grateful for more help on this issue. Thank you. "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" with "SERIES" highlighted? Any ideas |
#3
|
|||
|
|||
Dynamic chart problem (re-posted)
A problem with your computer doesn't mean that you have to repost the
message. The message is still there, and can still be read, with its replies. You can either read it in the newsgroup directly (providing that you set your newsreader options not to hide read messages), or read it in the Google archive: http://groups.google.com/group/micro...9629491cd0de96 I suggest that you re-read the advice from Jon and from me. In the *existing chart* you need to *select the series* which you want to edit. What does the series formula in the chart show you *before* you try to change it to the formula which you say is being flagged with the "function is not valid" for the series function? -- David Biddulph hoyos wrote: I had to re-post this question due to problems with my computer, which are sorted now.......hopefully!!! Previous help from Jon Peltier and others were very much appreciated but unfortunately did not work. I would be grateful for more help on this issue. Thank you. "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" with "SERIES" highlighted? Any ideas |
#4
|
|||
|
|||
Dynamic chart problem (re-posted)
In my last post on your previous thread, I asked you to make a chart
with regular data and paste the series formula here. - 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" with "SERIES" highlighted? Any ideas |
Thread Tools | |
Display Modes | |
|
|