I have a PIVOT CHART that will be updated daily. I have hidden the blank columns in the chart by unchecking in them in the PIVOT Chart. When I refresh and a new day is added because of this, I have to manually go into the chart and check the new day for it to update. I am sure there is an easy fix for this but not seeing it. Any info much appreciated. Thanks.
Bookmarks