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?

Jon Peltier has instructions for creating a dynamic chart:

http://www.geocities.com/jonpeltier/...html#DynColCht

Anonymous wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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%20Chart.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


"Anonymous" <(E-Mail Removed)> wrote in message
news:wOZpb.222$(E-Mail Removed)...
> 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?
>
>