Hi all. I have to do 3 set of charts monthly for 15 different depts. For example January has 3 sets of data and I have to create charts for 15 different depts. That's 45 charts in all for each month. I created the charts already. I have the data on one sheet and created the charts on different sheets and label it. My problem is I don't want to recreate the charts every month. If I change the data sheet or add data, the charts become distorted and I have to go through and select the data for each chart again. How can I change the data on the data sheet and have the charts update automatically?
Thanks
Bookmarks