How to update the chart automatically

[freger]

Hi,

I have many charts and I am currently doing a very tedious
task. There are so many charts and each month, when the
source data has been updated, I have to go to the charts
to manually drag to the new period. Is there a way to
update the chart automatically. I have different types of
charts, some are line, bar and charts using 2 Y-axises.
Can someone advise.

Thank you.

 

[Debra Dalgleish]

Jon Peltier has instructions for creating dynamic charts:

http://www.geocities.com/jonpeltier/Excel/Charts/Dynamics.html