Chart dynamic range from pivot table

[bahiapt]

Hi all,

I need to do a dynamic range from a pivot table (not pivot chart) and i am using the formula below in a named range:

--Label
day
=pivots!$MZ$6:INDEX(pivots!$MZ:$MZ,COUNTA(pivots!$MZ:$MZ)+1)
---------------------------------------------------------------------------------


values
unique cookies
=pivots!$NA$6:INDEX(pivots!$NA:$NA,COUNTA(pivots!$NA:$NA)+1)






sum_impressions
=pivots!$NB$6:INDEX(pivots!$NB:$NB,COUNTA(pivots!$NB:$NB)+1)






frequency
=pivots!$NC$6:INDEX(pivots!$NC:$NC,COUNTA(pivots!$NC:$NC)+1)




Now these named ranges are doing well when the chart is populated, now when there is no data at all in the pivot the ranges will say there is one row with data.

Anyone has any idea what is going on?

Best Regards,

Daniel