Charts in defferents tabs transfer of DATA

Closed
Report
-
Hello,

I have a workbook divided in 12 tabs (12 month), each tab have exactly the same charts and cells.In other words, each tab are copy paste from each other but for different month. The charts/graphs are based on data that i input every month. The data imputed is always different for each month.Here comes the problem, I did everything in the first tab (January) and i am trying to transfer to the 2 tab(February) doing copy/paste. The problem that i have now is, the charts in tab 2 are using data from tab1. When I do "select data", it shows "JANUARY!" instead of "FEBRUARY!". The only way to fix it is to change it manually but it takes too long. Does excel has another way to do it faster?