I am looking for any insight or assistance on trying to show axis/category labels for every category in a serial chart within an Operations Dashboard. Currently, I have a dataset that uses a column to group records by specific values (age range; 0-19, 20-29, 30-39,etc). When entering this data into a serial chart and using the "Group Values" option in the "Data" tab, I am unable to get every category in the column to appear/be labeled in the serial chart. Specifically I am finding this occurs when there are 0 (zero) entries or records that have this value. I have tried using the "+ Override" and "Load Categories" option in the "Category axis" tab, but this does not resolve this issue. I believe this is occurring due to the value I need labeled not occurring the dataset (zero records with that specific value). I also have a "Filter" being used on this chart, although I am not sure if this would have any effect on the ability to have all labels visible on the serial chart.
What I need is for regardless of the number of records with these values, for the labels to be displayed on the serial chart. Is there an option within the serial chart to allow for this functionality?