Hi,
I'm loading in data from a .xls file.
One of the charts I'm using is based on a field with 2 categories (A,B), but some entries don't apply to any of these 2 categories, they just have a blank space.
The pie chart is correct, showing all values divided in three sections, but in the legend I get only categories A and B. I would like to show in the legend another category "Undefined" or "TBD" for entries with blank space.
Is it possible to define that all entries not falling on categories "A" or "B" are shown under category "Undefined"?
Thank you!
