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
Bookmarks