Automatically generate graph

[Anonymous]

let say I want ot automatically generate graph in excel.
So toay i want to generate graph for cells A1 through A8
for the x axis and C1 through C8 for the y axis.
But tomorrow I want the graph to be automatially updated
to A1-A9 and C1-C9 when i enter new data into the cells.
Is there a way to generate an updated graph automatically?

 

[Debra Dalgleish]

Jon Peltier has instructions for creating a dynamic chart:

http://www.geocities.com/jonpeltier/Excel/Charts/Dynamics.html#DynColCht

 

[NealUK]

I have a similar sort of chart stored on a webspace. If it's of any use,
feel free.
It uses a combination of macros. the address is
http://www.epoch2001.fsnet.co.uk/chart/Auto Chart.xls

It was meant as a bit of fun when i did the celbdaq thing
Fell free to rip it apart to see how it works.
Just enter the details in the shaded area, and click the "Update" button
regards
Neal