Automatically update charts for only the most current 12 months?

A

AIEC33

I am trying to update 8 different charts in one workbook. The charts are
based off of one table that is a running total for 1997-2005 and is
continually being updated monthly. The charts only show the most current 12
months. How can I make the charts get updated automatically. The data is
entered in column by column.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 charts: want to avoid zero values 1
Chart SERIES OFFSET 5
Addional Data Series on Dynamic Chart 2
Dynamic Chart Title With 3D Stacked Column Chart 2
update chart after filter 2
Presenting all months in a year in a Pivot Table/Chart when allmonths are not included in source dat 0
2007 Table Linked Charts - Limit Data Source Range? 1
Using =Offset in Charts 1

Top