Hi
I need to plot gaps (not zeros or any othe value) on charts when cells are empty.
The values of the cells are results of GETPIVOTDAT functions, where i use a condition to empty the cell instead of filling with zero.
The formula is like this one:
=IF(ISBLANK(GETPIVOTDATA("#ccts";'Pivot_90%'!$A$3;"SLA_TIPO";"TIPO2";"tipo_circuitos.Tipo";"Carro";"Ano_Mes_Pronto";$B5));"";GETPIVOTDATA("#ccts";'Pivot_90%'!$A$3;"SLA_TIPO";"TIPO2";"tipo_circuitos.Tipo";"Carro";"Ano_Mes_Pronto";$B5))
I have a mix of charts types, line and bar, and any of them can have empty values
Thanks
Bookmarks