+ 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
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    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)

Similar Threads

  1. VBA to update PivotChart without changing chart size
    By kidwispa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-20-2013, 04:19 AM
  2. Changing / Masking Category Names on a PivotChart
    By Rob_Clark in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-09-2008, 10:25 AM
  3. Changing the defalut Pivotchart
    By Spirix23 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-08-2006, 12:15 AM
  4. [SOLVED] How do I not lose formarting when I refresh a PivotChart Report?
    By jpgrimes22 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-11-2006, 05:40 PM
  5. Changing Displayed Data and Legends thru VBA
    By BenWeber in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-24-2006, 03:10 PM
  6. [SOLVED] Changing what is displayed in the formula bar
    By Christina L. in forum Excel General
    Replies: 7
    Last Post: 10-28-2005, 08:05 PM
  7. [SOLVED] [SOLVED] Time scale axis should be available in PivotChart Report.
    By vertblancrouge in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-07-2005, 05:06 PM
  8. Macro and Pivotchart report
    By Orlandorei in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-19-2005, 04:33 AM

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