I have a chart, which uses the group function, in order to display a dynamic number of series. Unfortunately, in order for this to work properly, each series must contain a record for each category (in this case, month). If not, columns are displayed in the incorrect category, and the chart has missing x-axis labels.
However, I also want each column to have a label showing the value, but the chart also shows labels for the 0 value items.
How can I remove these zero labels (or show dynamic series without adding the values in, in the first place!)?
The chart definition is:-