F
Frozenyogurt
I work for the Court and I am trying to show the percentage of 2 types of
cases (CC and SP) to the total judicial caseload, in five different separate
locations, on one graph. I developed a stacked chart which shows the values
(number of cases) of each type (CC or SP) per location. I was also able to
also show the value only of the total number of cases (CC + SP) and keep the
original chart format without adding a third stack on top by entering a third
series as the total value, but making this series transparent and aligning
the total value at bottom of stacked series of CC & SP cases. NOW I want to
keep the total number of cases on top of the 2 stacked bars for # of CC and
SP cases, but need to show them as a percent of the total, not the actual
number. This would mean mixing values and percentage data labels, but I
thought I could do it using a 2Y axis and making it transparent.
Mr. Excel, or any other expert, are you out there? Help! As you know, the
percentage works on the pie graph, but I can't do grouping by the five court
locations in that format. How can I get it to work on the stacked bar graph,
and still keep the total on top as a value, not a percentage (which would
obviosly be 100%)? Will send file if that helps. Thanks, Lorah in Miami,
Florida State Courts System.
cases (CC and SP) to the total judicial caseload, in five different separate
locations, on one graph. I developed a stacked chart which shows the values
(number of cases) of each type (CC or SP) per location. I was also able to
also show the value only of the total number of cases (CC + SP) and keep the
original chart format without adding a third stack on top by entering a third
series as the total value, but making this series transparent and aligning
the total value at bottom of stacked series of CC & SP cases. NOW I want to
keep the total number of cases on top of the 2 stacked bars for # of CC and
SP cases, but need to show them as a percent of the total, not the actual
number. This would mean mixing values and percentage data labels, but I
thought I could do it using a 2Y axis and making it transparent.
Mr. Excel, or any other expert, are you out there? Help! As you know, the
percentage works on the pie graph, but I can't do grouping by the five court
locations in that format. How can I get it to work on the stacked bar graph,
and still keep the total on top as a value, not a percentage (which would
obviosly be 100%)? Will send file if that helps. Thanks, Lorah in Miami,
Florida State Courts System.