Hello, I have a pie chart that either shows 3 items or 4 items depending on the dropdown selection. It is for different locations that can have either two 12 hr shifts or three 8 hr shifts and an "unknown" time for both.
I currently have the "maximum" number of cells selected for the graph and so when 12 hr is selected I have a blank that shows up on the graph (see attached). I'd like it to only show the three 7a-7p and 7p to 7a and unknown when that is selected and the four 7a-3p, 3p-11p, 11p-7a and unknown when 8 hr is selected.
I have tried the "Hidden and Empty Cells" on the select source data option but none of the selections I make work to hide it. It is probably an easy fix but I haven't stumbled on it yet.
I've attached the graph.
Thanks much!
Bookmarks