Thread: Charts dont work on copied sheets / tabs

Hi Everyone,

I'm currently using excel 2007 and can't for the life of me figure out why my charts won't work when I create new tabs.

I have created a spread sheet for finances and have charts that correlate to the formulas in certain cells. I created my first one "JAN" and created 11 more copies of that sheet for the rest of the months. So at the bottom I have 12 tabs (one for each month). The formulas work on all the tabs / sheets, but the charts only work in my original tab "JAN" . Every other copy they don't work.

I'm clueless. Any ideas? Thanks