More dynamic to rolling chart

**mario17** · 02-05-2014, 07:16 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.

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, 07:17 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

**Kaper** · 02-06-2014, 07:10 AM

probably answer is simple (could be that you shall use named range as a source of your series, not formula in the series description), but frankly speaking: I'm too lazy to copy your data to sample workbook - attach one yourself and show what has been already done (see http://www.excelforum.com/forum-rule...rum-rules.html for additional explanation).