How do you change data that is displayed in a PivotChart Report?
How do you change data that is displayed in a PivotChart Report?
You change the data and then you need to refresh the data (right-click the pivot then refresh).
If you have changed the location or size of the raw data you need select somewhere in the pivot then Analyze -> Change Data Source
I use a table to store data for pivots, so my data source reference is to the table name not a specific set of cells. I only need to refresh the data when I change it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks