Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic chart problem | Charts and Charting in Excel | |||
Dynamic chart problem | Excel Discussion (Misc queries) | |||
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 |