Automatic range update of Graph

[p.strijbosch]

Hello,

Can some one tell me if it is possible to automatically update the
(date) ranges in a graph?
Now I have to extend the ranges manually each time there is a new range
provided.

Thanx in advance!!!

Regards,
Robert

 

[Gord Dibben]

Have a look at Tushar Mehta's Dynamic Ranges site.

http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

Or Jon Peltier's site on Dynamic Charts

http://peltiertech.com/Excel/Charts/index.html#hdrDyno


Gord Dibben Excel MVP