Hi All,
I have got a Form for which the default view is Pivot chart and a control source is a query. When the pivot chart is opened it pulls up the date on the xaxis and the total efficiency on the y axis. Is there a way to hide the zero values on a pivot chart were the total efficiency is nil.
I for some reason cannot change the query as it feeds into many other items.
Please look at the example chart. Cheers.