Hi all,
I have a bar chart of which data source is a pivot table. The pivot table contains names in the rows field, activities in the columns field and hours plotted against these. Names are currently in column A, and activities in columns C-T but the data is dynamic.
The pivot table has multiple 0 values which appear on the chart but are unwanted. As the chart updates automatically when the data is refreshed, the filter on the pivot table cannot be used to remove the 0 values because the filter would need to be removed first, and then have the data refreshed, each time the user needs the chart to update correctly with the new data.
Is there a way to extract the rows from the pivot table, but only if the values (in columns C-T) in the row are not either all 0s or blank values, that also automatically updates when the pivot table data is updated?
Thanks
I have a bar chart of which data source is a pivot table. The pivot table contains names in the rows field, activities in the columns field and hours plotted against these. Names are currently in column A, and activities in columns C-T but the data is dynamic.
The pivot table has multiple 0 values which appear on the chart but are unwanted. As the chart updates automatically when the data is refreshed, the filter on the pivot table cannot be used to remove the 0 values because the filter would need to be removed first, and then have the data refreshed, each time the user needs the chart to update correctly with the new data.
Is there a way to extract the rows from the pivot table, but only if the values (in columns C-T) in the row are not either all 0s or blank values, that also automatically updates when the pivot table data is updated?
Thanks