I have a pie chart that needs to be updated in the preview mode when a value is entered in the "value" component. This value is linked to a fixed cell (call it cell X) in the excel worksheet, that updates a pivot table. The source data from pie chart is linked to this pivot table so each time I change the value from cell X, the pivot table refreshes automatically and the pie graph refreshes too, but when I toggle to the preview mode and insert a value in the value component, the pie graph does not refreshes and shows the same data. Could you please help me with this issue? How can I refresh the pie chart in the preview mode when i enter a value in the value component linked to the cell X?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.