+ Reply to Thread
Results 1 to 2 of 2

choosing what columns from pivot table show on chart without removing columns from table

  1. #1
    Registered User
    Join Date
    02-07-2022
    Location
    Calgary, AB
    MS-Off Ver
    2201
    Posts
    1

    choosing what columns from pivot table show on chart without removing columns from table

    Can I choose what columns of data from a pivot table display on a chart without removing the unnecessary columns from view on the pivot table? I have a pivot table with 32 columns of data and we like to look at the table with all data in view, but I want to create 4 different charts each displaying the data from a few different columns. When I make the chart it pulls all 32 columns, and when I try to remove a column it removes it off the pivot table too.

    I want my spreadsheet laid out like this:

    pivot table with all rows and columns visible
    chart 1
    chart 2
    chart 3
    chart 4

    so you can scroll through the table then continue scrolling to see each chart.

    Also want to mention that I add new rows of data to the original "raw data" tab occasionally. My pivot table can be refreshed to include the new data of course, but just wanted to mention it in case the solution to my chart issue includes manipulating the original source data.

    Thanks for the help!

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: choosing what columns from pivot table show on chart without removing columns from tab

    You can do this by overlaying the pivot table with named dynamic ranges and using them as the chart data series. Without a sample workbook, I can't show you how that's done.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Double-clicking pivot table - removing columns from the resulting sheet
    By Accountnt in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-10-2020, 01:58 PM
  2. Show all columns in pivot table
    By bongielondy in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-24-2013, 07:10 AM
  3. Removing or Clearing Pivot Table Columns
    By AHFoddeR in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-22-2013, 12:31 AM
  4. [SOLVED] Multiple Columns in Pivot Table (but don't show in Pivot Chart)
    By Gideon1973 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-23-2012, 10:57 AM
  5. Replies: 7
    Last Post: 08-04-2011, 09:32 AM
  6. [SOLVED] Excel 2007 : Choosing The Columns in Pivot Table by Menu
    By mhraja in forum Excel General
    Replies: 5
    Last Post: 03-18-2011, 12:51 PM
  7. Replies: 2
    Last Post: 04-14-2010, 05:26 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