I have set up a chart based on a query which does a count. The categories are numerical and can either be 1,2,3,4. Is there anyway for the chart to display an empty space when, for example, there are no results for category 3.
The reason for this is that I have a standard legend which I am using for this report and the colours don't match if any of the categories equal zero.
Hope this makes scense
The reason for this is that I have a standard legend which I am using for this report and the colours don't match if any of the categories equal zero.
Hope this makes scense