I did that only, but the problem here is all the values in highlighted range are pulled from formula, that means, there is a formula in the highlighted range, and it is returning value, wherever it is matching the criteria, and leaving blank where criteria is not matching.Hi
I think you are close.
On your chart series replace the highlighted range by the correct name manager reference and you will be ok. The sheet reference needs to stay.
View attachment 52105
Have a read on this. I'm sure you will get it.
https://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/
Thank you Very much, this was very helpfulTry this in your offset formulae:
- use count, not counta: count will only consider number values, not text.
- remove the -1, because you are not counting the title.
Q? Could there be blanks in between the values? Or is it then "0"?
Thank you Chihro, it was great, but how it was doneJust use Excel Table structure and/or PivotTable.
No need to maintain Named Ranges. It will auto adjust to include added data.