automatic charting from user input

[Goslings]

Please see attached excel

Yellow boxes are for user to input over time, I just want the charts to update automatically with the data for each row that is added.

I've seen examples of this, but not for data running across the page, and not for more than one chart.

I posted this in excel forum couple of weeks ago, but sadly, 113 view but no advice

Many thanks
goslings

 

[lohithsriram]

Hi Goslings,

What are you trying to achieve here? Do you want these 3 charts to get automatically change when a new row of data is added? or do you want a new chart to be added with a new row?

 

[Goslings]

Yes thanks the former
Charts to update automatically with each new row of data
Thanks

 

[lohithsriram]

Hi Goslings,

There is a very good explaination of creating the charts with dynamic range of values. Check this out.
I hope this is what you are looking for

http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/

 

[Goslings]

thanks I have seen this.
This is all for data in cols, mine is in rows, and multiple data, which does not to me appear to behave the same way, and I can't make head nor tail of it. Hence the post to see if gurus have any thoughts

 

[Goslings]

seems such a simple thing, and I can believe nobody has encountered this in this forum.
I should say that I am not just extending the graph, but extending it with what I would like plotted as another series. This is the tricky bit I think.

Ah well I'l try another forum.