+ Reply to Thread
Results 1 to 2 of 2

Charting pivot table results

  1. #1
    Registered User
    Join Date
    10-08-2020
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    2

    Charting pivot table results

    Hi, hope someone can help.
    I have a pivot table that shows number of players in a club. There are multiple teams who play on a variety of days. I would like to show a series of graphs which show results based on the filters applied (game date, team, position,player name).
    I have pivot tables that counts the number of players in attendance on the selected day, but I want to show this as a percentage of ALL the players in that division (including if no-one from a division turns up).
    Can this be done with either power query or pivot tables/relationships.
    Thanks in advance

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

    Re: Charting pivot table results

    It may be easier for someone to answer your questions if you upload an .xlsx file that shows your source data and existing pivot tables.
    Instructions for uploading are given in the banner at the top of the page.
    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. Replies: 5
    Last Post: 07-01-2019, 08:01 AM
  2. Pivot Table Results to Secondary Table with Horizontal Results
    By Pony08 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-07-2015, 04:18 PM
  3. [SOLVED] Charting percentiles (using Pivot Table)?
    By Smudge.Smith in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-29-2015, 05:55 PM
  4. Issues with charting pivot table
    By bogdn in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 06-03-2013, 09:02 AM
  5. Charting A pivot table
    By TonyforVBA in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-04-2012, 07:56 AM
  6. Pivot Table Charting
    By office07 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-02-2007, 11:19 PM
  7. Problem with series when charting from a pivot table
    By Dan in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-07-2005, 12:06 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