+ Reply to Thread
Results 1 to 2 of 2

Creating a Chart from select columns/rows in a Pivot Table

  1. #1
    Registered User
    Join Date
    12-04-2015
    Location
    california
    MS-Off Ver
    2013
    Posts
    21

    Creating a Chart from select columns/rows in a Pivot Table

    I try to create both a normal and pivot chart based on select columns in a pivot table, but the chart shows all columns. How do I just create the chart based on select columns only?

    PS- I know I can just deselect certain columns from the Values area but it gets tedious taking them out and putting them back in

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

    Re: Creating a Chart from select columns/rows in a Pivot Table

    Please attach a sample workbook. It would be easier to understand the requirement and implement a solution.

    The solution would be to develop the chart based on a named range, and then change where the range points based on the selection.

+ 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. Creating chart visualizations from excel pivot table
    By tdm in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-27-2014, 08:53 AM
  2. Creating a mini table to summarise a pivot chart
    By no.18shirt in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 05-09-2013, 07:36 AM
  3. Creating a pivot table and chart ..
    By adfo in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-23-2013, 02:14 AM
  4. Creating a chart, can't get a pivot table to work.
    By arcing in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-21-2013, 08:40 AM
  5. creating a pivot table and a chart
    By wawawiwa in forum Excel General
    Replies: 2
    Last Post: 04-29-2010, 04:44 AM
  6. Chart Pivot Table - How to Select Only 12 Records?
    By jbates99 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-31-2009, 06:26 AM
  7. Select columns when drilling into a Pivot Table
    By Smythe32@aol.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2006, 08:10 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