+ Reply to Thread
Results 1 to 6 of 6

Pivot Chart

  1. #1
    Registered User
    Join Date
    10-01-2014
    Location
    Melbourne,Australia
    MS-Off Ver
    2010
    Posts
    21

    Red face Pivot Chart

    Hello everyone,
    I am having the pivot table to display the school activities,which are grouped into A,B,C,D. I have junior and senior student groups. I like to
    draw one junior pie chart and one senior pie chart to compare the activities attendance between them for each year. Is it possible to do that
    with one pivot table.
    I want use the slicer for year selection. Saying when I select 2012 both the pie chart will display.
    How do I do it ?
    HELPPPP!!!

  2. #2
    Forum Contributor
    Join Date
    03-06-2013
    Location
    Salt Lake City, Utah
    MS-Off Ver
    2007, 2010
    Posts
    127

    Re: Pivot Chart

    mhghg,

    Try this. Sheet4.


    Book2.xlsx
    BrownBoy

    If happy, mark "SOVLED" & add to "REP"

  3. #3
    Registered User
    Join Date
    10-01-2014
    Location
    Melbourne,Australia
    MS-Off Ver
    2010
    Posts
    21

    Re: Pivot Chart

    OK thanks!

  4. #4
    Registered User
    Join Date
    10-01-2014
    Location
    Melbourne,Australia
    MS-Off Ver
    2010
    Posts
    21

    Re: Pivot Chart

    How do I mask "Solved", and what is "REP"?

  5. #5
    Forum Contributor
    Join Date
    03-06-2013
    Location
    Salt Lake City, Utah
    MS-Off Ver
    2007, 2010
    Posts
    127

    Re: Pivot Chart

    You're welcome. You didn't give us any data to build your pivot table and pie charts from so I attempted to guess. If you're satisfied, please close the thread and add to my reputation. If you are not satisfied then please elaborate on your desired end state and provide sample (made up) data.

    Thank you.

  6. #6
    Forum Contributor
    Join Date
    03-06-2013
    Location
    Salt Lake City, Utah
    MS-Off Ver
    2007, 2010
    Posts
    127

    Re: Pivot Chart

    Thread tools to close the thread as "Solved" see images for a quick reference.

    Capture.PNG Capture1.PNG

+ 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. 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
  2. How to add target line to stacked column pivot chart chart
    By oleg mirzaev in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-04-2013, 07:46 AM
  3. Replies: 2
    Last Post: 05-24-2013, 03:58 PM
  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: 3
    Last Post: 09-11-2010, 06:55 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