+ Reply to Thread
Results 1 to 3 of 3

Adding Pivot Chart Fields

  1. #1
    Registered User
    Join Date
    12-20-2016
    Location
    South Carolina, USA
    MS-Off Ver
    2013
    Posts
    3

    Question Adding Pivot Chart Fields

    Good Morning,

    I am working with an excel file with a Pivot table in it.
    I am wondering how to add a new Pivot Chart Field to my list of available fields (see image below)
    Pivot-Fields.JPG

    I need to add some demographic fields like, Age, Duty Station, Office, Grade level,....

    But I can't seem to find any information on how to add brand new chart fields, just how to include ones already in the list.

    Thanks in advance for any assistance you can give on this.

    Ike

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Adding Pivot Chart Fields

    It seems you already have this in your raw data sheet, but for some reason is not included in the pivot source data. Try this

    - Click anywhere on the pivot table
    - Analyze Ribbon -- Change data source -- Change data source

    Ensure the source data has the requisite fields you want, then click OK

    These should now show up in the pivot table and pivot chart fields
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    12-20-2016
    Location
    South Carolina, USA
    MS-Off Ver
    2013
    Posts
    3

    Re: Adding Pivot Chart Fields

    The issue I have is that the Pivot table Source data does not pull the Demographic data.
    I have included a copy of the source data (some of the data) that is used for this table.
    Soource-Data-Pic.JPG

    Not to mention the source data is on a different sheet/ tab from the Demographic data

    IKE

+ 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. adding multiple fields/columns in a pivot table
    By JackSmith123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2015, 03:58 PM
  2. Pivot Chart from three data fields
    By mrplow911 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-18-2014, 11:30 AM
  3. Keep Calculated Column Next to Pivot When Adding fields
    By beckms in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-23-2014, 04:46 PM
  4. [SOLVED] Adding Calculated Fields to a Pivot Table Code
    By dwhite30518 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2012, 06:36 PM
  5. Adding Calculated Fields/Formulas to a Pivot Table
    By SigueSigue in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-25-2011, 08:27 AM
  6. Removing and Adding Pivot Table Fields
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-01-2006, 09:00 PM
  7. Moving Pivot Chart Fields on a chart sheet
    By sherobot in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-28-2006, 05:15 PM

Tags for this Thread

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