Auo-update chart?

Hello all,

I have a workbook where I’m entering data in each tab each week (Week 1, Week 2 etc.). It's quite a bit of data. Anyway, in the last tab, I want a bar chart (a few of them actually) showing the progress each week (ups and downs and all that). However, I’m finding it difficult to link the chart to more than one tab. Each time I “add” to the chart by going into the next tab it wants to erase the old data. Is there a trick to this? As I enter the data into each tab, I want the chart to auto-fill. Is there an easy way to do this? Am I being thick here?

Thanks for your help!

J

Thanks. I actually love dashboards, and they're relatively easy for me when linking them to a pivot table (basic ones anyway)...but I'm not sure how I'd link them to each tab of the workbook. I'll check out the book you mentioned though and see what everyone else has to say. I appreciate your input!

Hi Andy,

Yes, that is what I was doing (oops). Not sure I understand the second part of what you're saying though. I'll try to post an example in a bit. Thanks for the reply.

J

Ah, gotcha. I was also thinking of having all of the data go into one tab that labeled historical, so the chart could run off of that one tab.