Auto Update Graphs

[Jod84]

At the end of each month I prepare a dozen or so rolling graphs some are 2 years and some are 10 years on a variety of items from exchange rates to fuel and electricity prices. But every sheet has the same format dates are in column A (going back as far as we have them in some cases 20 years) one record for each day of the month (some won't include weekends) and values are in column B.

I'm just wanting to know how I can auto update the chart to include either 2 years or 10 years rolling as i currently waste several hours a month doing this and their must be a better way. I've read some items on creating named ranges using offsets but this seems to just increase the size rather then move the graph.

 

[Jon Peltier]

In this tutorial I show how to make a dynamic chart that shows the last 12 months. You can easily modify it to cover the last N periods:

Chart the Last 12 Months

 

[Jod84]

In this tutorial I show how to make a dynamic chart that shows the last 12 months. You can easily modify it to cover the last N periods:

Chart the Last 12 Months

Jon,

Thanks for the tutorial its really good I'll have to look around yoru site when I get more time looks interesting.

Thanks

Josh