+ Reply to Thread
Results 1 to 2 of 2

Pivot chart from pivot table with multiple columns

  1. #1
    Registered User
    Join Date
    07-20-2021
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    8

    Pivot chart from pivot table with multiple columns

    Hi,

    I have a pivot table with multiple columns. Is it possible to create chart as below:
    1. Select 1st 2 columns and create a chart.
    2. Then, select the next, say 1st and 3rd column and create a chart. and so on.

    Basically would like to create multiple charts with different columns of the same pivot table.

    Thanks.

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,039

    Re: Pivot chart from pivot table with multiple columns

    Select "No fill" and "No line" for the chart series you want to exclude and remove the series name from the Legend Entry.

+ 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. Chart of only some of a Pivot Table's columns
    By Ricko_uk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-26-2020, 10:59 PM
  2. Replies: 7
    Last Post: 02-27-2017, 07:41 AM
  3. Automating Pivot table and pivot chart creation if data table names unknown
    By Vegiepie2016 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-04-2016, 11:52 AM
  4. Creating a Chart from select columns/rows in a Pivot Table
    By dreamer001 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-23-2015, 03:04 PM
  5. Replies: 1
    Last Post: 07-22-2015, 07:16 AM
  6. 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
  7. [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

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