Hello
I have the offset with counta to show only active entries but for some reason on my graph, it is still showing blank entries
basically, im showing data for states, some states have 6 cities, some have 4. the graph looks fine when it has 6 cities showing, but when its 4 it messes up and shows a 0 on the graph. here is my main offset formula
=OFFSET(Reference!$A$19,0,0,MAX(1,COUNTA(Reference!$A$19:$A$26)-COUNT(Reference!$A$19:$A$26)),1)
i have attached a sample workbook, if someone can pls help me out on this..ive been stuck on this for a whole day and half :S.
Bookmarks