+ Reply to Thread
Results 1 to 2 of 2

Changing text in pivot table

  1. #1
    Registered User
    Join Date
    02-04-2020
    Location
    New York, NY
    MS-Off Ver
    2016
    Posts
    1

    Changing text in pivot table

    I inherited a database that I now need to edit. There is a summary tab with a hidden pivot table and an overview graph. The overview pulls from the pivot table. The pivot table pulls from a summary worksheet. I don't know how the person built this pivot table and I'm having trouble editing it. The data is not changing, but the way we are categorizing the data is changing. For example, we're now not counting "pets" but rather "dogs" and "cats."

    How do I go about changing the pivot table and changing the info on the summary worksheet so they continue to link? The text needs to be changed because we are re categorizing, but technically it's all the same data.

    Clearly I'm a newb at this, so simple help is much appreciated.

    TIA.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Changing text in pivot table

    Administrative note

    Welcome to the forum

    missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

+ 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. Pivot table filter not changing data in table - Using macro
    By DJDRU in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-09-2016, 06:16 AM
  2. Changing (blank) in a Pivot Table to Alternative Text
    By HangMan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-21-2015, 02:15 AM
  3. [SOLVED] Pivot-table changing with changes to pivot chart
    By JackSmith123 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-05-2015, 08:13 AM
  4. Changing a pivot chart column color based on the pivot table category
    By Shawne in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2014, 09:12 AM
  5. [SOLVED] Dynamically Changing Position of Pivot Based on Size of Another Pivot Table
    By ggilzow in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2013, 02:42 PM
  6. Changing the value in a pivot table
    By stanfox in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-24-2012, 04:34 AM
  7. Pivot table, changing the criteria in the parent table
    By James_SF in forum Excel General
    Replies: 3
    Last Post: 04-22-2011, 09:04 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