+ Reply to Thread
Results 1 to 2 of 2

Changing Data Displayed in a PivotChart Report

  1. #1
    Registered User
    Join Date
    11-14-2017
    Location
    Woodbridge, Virginia
    MS-Off Ver
    2016
    Posts
    1

    Changing Data Displayed in a PivotChart Report

    How do you change data that is displayed in a PivotChart Report?

  2. #2
    Registered User
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    2016
    Posts
    57

    Re: Changing Data 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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1