Graphing Changing Information

[CDotWin]

I want to make a graph that will expand and condense anytime that new information is inserted into a linked worksheet. What happens now is that the graph condenses all of the information, so that it displays extremely crunched together and sometimes it skips some of the rows all together (i.e. it will display the first column and then skip to the 4th or 5th column.) I also want the information to be able to be seen.

Please HELP

Thanks

 

[Jon Peltier]

You could make a chart based on dynamic ranges, that include the filled
cells, and skip the empty ones at the end. On this page I have a few
examples and lots of links:

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

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