Hi

I'm trying to create a chart to show the number of sales on each day.

The problem is that although I want to show days during the week with no sales, I don't want to show the weekend days on the chart.

I've ticked the 'Show missing values' box in the settings so that the chart shows the days without a value as there were no sales on them and had hoped that using a filter to exclude the closing day of Saturday or Sunday would then, in turn, hide those dates from the x-axis of the chart but it still shows all the dates.

Any idea how I can hide the weekend dates from the x-axis of my chart?

Thanks in anticipation.