+ Reply to Thread
Results 1 to 2 of 2

Multiple pivot charts showing different data for same pivot table

  1. #1
    Registered User
    Join Date
    03-28-2019
    Location
    London
    MS-Off Ver
    2016
    Posts
    10

    Multiple pivot charts showing different data for same pivot table

    This may have been solved or addressed previously but I haven't been able to find the appropriate forum.

    I have a pivot table which sorts by 2 groups of data (with multiple sub-data), years and quarters, and has two sets of values (Won/lost).

    I want to generate multiple different pivot charts which represent different aspects of the same pivot table and change accordingly.

    For example I have one stacked column chart to display won/lost per sub-group. But I would also like to include Line charts, pie charts, bar charts which represents the data differently.

    For example I would like the pie chart to just show the grand totals, and show by percentage. Or for the line chart, the X axis should represent the years (not sub-group) and show a trend over years.

    I am struggling to find out how this is approached.

    Thanks for help in advance.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Multiple pivot charts showing different data for same pivot table

    From what I have read (post #8) I don't believe that you can generate multiple different pivot charts from one pivot table, however I feel that you can generate multiple different regular charts from one pivot table.
    Here is a tutorial that describes the Making Regular Charts from Pivot Tables.
    If the tutorial does help for what you want, please upload a small desensitized sample of the data as well as the pivot table generated from that sample.
    To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. [SOLVED] Adding multiple pivot charts on different sheets in same workbook from one pivot table Exc
    By GregBlosh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2017, 08:33 PM
  2. Replies: 1
    Last Post: 07-29-2016, 04:30 PM
  3. Replies: 0
    Last Post: 07-10-2013, 08:15 AM
  4. Power Pivot with multiple pivot charts using different pivot data
    By Paul-NYS in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-10-2013, 10:18 AM
  5. Replies: 3
    Last Post: 09-20-2011, 05:02 AM
  6. Create multiple pivot charts from one pivot table
    By SueWithQuestion in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 07-13-2011, 12:29 PM
  7. [SOLVED] How do I create multiple pivot charts from one pivot table?
    By Rudy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-17-2006, 06:10 PM

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