Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
show value as percentage in stacked bar graph
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
show value as percentage in stacked bar graph
First, it might be better to use a line series, with no markers or line,
plotting the total, and use this as the labels for the total. Second, compute your percentages in the worksheet. Use one of these add-ins to use the calculated percentages in the worksheet as data labels for the stacked column series: Rob Bovey's Chart Labeler, http://appspro.com John Walkenbach's Chart Tools, http://j-walk.com - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Frozenyogurt" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
?make a combo chart with 1 stacked bar and 1 not stacked, + show t | Charts and Charting in Excel | |||
Cluster stacked graph AND line combo graph? | Charts and Charting in Excel | |||
Creating a graph similar to a stacked column graph | Charts and Charting in Excel | |||
Creating a stacked column chart with percentage in the graph | Charts and Charting in Excel | |||
How do I show negative numbers on a stacked graph | Charts and Charting in Excel |