I'm building a dashboard in Excel 2016 and I just added new data to my data source/table connected to my pivot tables/dashboard.
When I go to Pivot Chart Tool, Analyze Tab, Refresh menu item and select 'Refresh' when I'm on my Dashboard sheet, the data labels on one of the pivot charts on the dashboard get deleted. It only happens to one pivot chart.
Does anyone know why this happens and how do I fix it?
Also, is there a way to automatically refresh the pivot charts on my dashboard when I insert new data in my data source or when I update my data source?
Keith
When I go to Pivot Chart Tool, Analyze Tab, Refresh menu item and select 'Refresh' when I'm on my Dashboard sheet, the data labels on one of the pivot charts on the dashboard get deleted. It only happens to one pivot chart.
Does anyone know why this happens and how do I fix it?
Also, is there a way to automatically refresh the pivot charts on my dashboard when I insert new data in my data source or when I update my data source?
Keith
