Chart changing based on change in data source (number of rows/colu

[Bal Ram Bhui, Jakarta]

As I see, the data range for charting is normally fixed. I have to produce
chart based on chaning rows and/or columns in data source table. Has anybody
got some suggestion for me?

 

[Mike Middleton]

Bal Ram Bhui -

For Excel charts in general, I suggest Jon Peltier's web site:
http://www.peltiertech.com/

For dynamic charts, I suggest:
http://www.peltiertech.com/Excel/Charts/Dynamics.html

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel