Hi,
I have created a pivot line chart which tracks employee daily productivity scores, if there is no value - ie the employee didn't work that day or was not on the rota which would produce a productivity score, then i want the lines to connect to each other rather than dropping to zero.
I am able to do this on a non pivot chart by using the =na() function and altering the hidden and empty cells settings to "connect data points with line" yet, I am unable to get this to work on a pivot chart as this selection is greyed out.
I can't really not use the pivot as the users need to be able to select customisable date ranges and the graph should auto update to reflect that.
Does anyone know how this can be achieved?
Thanks
I have created a pivot line chart which tracks employee daily productivity scores, if there is no value - ie the employee didn't work that day or was not on the rota which would produce a productivity score, then i want the lines to connect to each other rather than dropping to zero.
I am able to do this on a non pivot chart by using the =na() function and altering the hidden and empty cells settings to "connect data points with line" yet, I am unable to get this to work on a pivot chart as this selection is greyed out.
I can't really not use the pivot as the users need to be able to select customisable date ranges and the graph should auto update to reflect that.
Does anyone know how this can be achieved?
Thanks
