Results 1 to 3 of 3

Pivot table bar graph- overlapping with percentages?

Threaded View

Blake-Oregon Pivot table bar graph-... 06-29-2012, 04:57 PM
MarvinP Re: Pivot table bar graph-... 06-29-2012, 05:48 PM
Blake-Oregon Re: Pivot table bar graph-... 06-29-2012, 11:06 PM
  1. #1
    Registered User
    Join Date
    06-29-2012
    Location
    Portland, Oregon
    MS-Off Ver
    Excel 2010
    Posts
    2

    Pivot table bar graph- overlapping with percentages?

    Hello,

    Brand new here at the forum, this is my first post.

    I made a pivot table which gave the total count of Registrations for each month. It also has a count of those, by month, who are still active. I wanted my graph to show the total registrations in one color, and then the "still active" in the same bar as a different color (to be able to visually appreciate both the volume of enrollment for each month, as well as the percentage of those enrolled each month who are "still active". I had then hoped to put that percentage in parenthesis above each of the the bars. Here's a look, and I've attached a sheet of the pivot chart.

    Thanks so much for your help with this!



    Data
    Registration Month Count of Registration Month Count of Still Active
    Sep. 175 103
    Oct. 45 22
    Nov. 39 18
    Dec. 28 18
    Jan. 66 46
    Feb. 63 38
    Mar. 60 47
    Apr. 13 12
    May 9 8
    June 1 1
    Grand Total 499 313
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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