Dynamic roll chart with formula?? how to test (offset) it?

**mario17** · 02-05-2014, 05:03 PM

Thanks to Peltier I did my chart like explained here:
http://peltiertech.com/Excel/Charts/DynamicLast12.html

Alas I need to put more dynamics and fill this data set from other sheets, so I'm putting formula into column A, and this force chart react and insert another category.
Can anybody help me how to resolve this? In other words I want to have this fill only if data present on different tab(worksheet).

That what I have now:

Please Login or Register  to view this content.

is there any other COUNTB,C,D???
COUNTA
Counts the number of cells that are not empty and the values within the list of arguments. Use COUNTA to count the number of cells that contain data in a range or array.

And thanks again to peltiertech.com for their sharing !!!!!

**mario17** · 02-05-2014, 06:27 PM

Hi, all again

I actually solved this replacing COUNTA for

Please Login or Register  to view this content.

But now I having other problem as it still treats this value like formula and doesn't update chart. I need somehow take value and paste it in new A cell as a "Value"???

Mario