Pivot table bar graph- overlapping with percentages?

[Blake-Oregon]

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

[MarvinP]

Hi Blake,

Have you tried to right click on the bar graph and then on "Change Chart Type"? Do these other types of charts (bar charts) offer you what you want?

[Blake-Oregon]

Thanks for replying Marvin!

I took a look at the other charts available, and the Stacked Column type comes close, lining up the bars behind each other, but I was hoping to combine them into one bar to show the ratio. Now that I think about it though, it may actually be more clear to show both graphs, and then manually enter the ratio below each month. Is there a way to insert text into the graph? Thanks so much for your help Marvin!

-Blake

Stacked Column Chart.png