A chart that allows for new data to be entered

[wjsubs]

I have a set of data that I need to put into a simple line graph.
need the chart to recognize and add new data points into its data se
as I enter the new values.

I have tried to extend the data range by another 40-50 empty cells s
that they will automatically be included when data is entered. Th
graph keeps coming up basically blank.

If anyone knows a fix for this, please let me know.

Thanks,
Wil

 

[Jon Peltier]

Will -

You can set up a dynamic chart, based on a dynamic range that updates as
data is added. For a few examples and a lot of links, check this page:

http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______