Dynamic chart problem (re-posted)

H

hoyos

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"
with "SERIES" highlighted?
Any ideas
 
H

hoyos

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.
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic chart problem 9
How do I insert a formula into chart source data values field box? 3
Chart SERIES OFFSET 3
dynamic charts - problem with copy 3
Dynamic charts in 2007 2
Can chart size be dynamically adjustable to fit data points? 2
User Selectable Series and Number of Series for Line Chart 2
Erroneous Error? re >32,000 data plots in 2D chart 3

Top