Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Percentage Column Charts
HI!! I think I am thinking too much about this and it is easier than it
seems, but I cant figure it out! hopefully someone can help. So I need to create a chart with 2 column...plan vs. actual. But I need each of these bar columns to be separted by percentages of the categories that make them up. EX: I need to make a comparison on how big of a percentage the Labor part of the Budget was when they planned and how it differs from the actual execution. Thanks for your help! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Percentage Column Charts
Stacked Column Graph
Set up as labor code ACT PLAN a 1 1 b 3 2 c 5 3 d 9 4 select series in "Rows" "stacy05" wrote: HI!! I think I am thinking too much about this and it is easier than it seems, but I cant figure it out! hopefully someone can help. So I need to create a chart with 2 column...plan vs. actual. But I need each of these bar columns to be separted by percentages of the categories that make them up. EX: I need to make a comparison on how big of a percentage the Labor part of the Budget was when they planned and how it differs from the actual execution. Thanks for your help! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Percentage Column Charts
Thanks! Is there a way to show the percntages, like in a pie chart?
"LanceB" wrote: Stacked Column Graph Set up as labor code ACT PLAN a 1 1 b 3 2 c 5 3 d 9 4 select series in "Rows" "stacy05" wrote: HI!! I think I am thinking too much about this and it is easier than it seems, but I cant figure it out! hopefully someone can help. So I need to create a chart with 2 column...plan vs. actual. But I need each of these bar columns to be separted by percentages of the categories that make them up. EX: I need to make a comparison on how big of a percentage the Labor part of the Budget was when they planned and how it differs from the actual execution. Thanks for your help! |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Percentage Column Charts
Calculate your percentages in the worksheet, then use one of these utilities
to apply the calculations as data labels: 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 Peltier Technical Services, Inc. - http://PeltierTech.com _______ "stacy05" wrote in message ... Thanks! Is there a way to show the percntages, like in a pie chart? "LanceB" wrote: Stacked Column Graph Set up as labor code ACT PLAN a 1 1 b 3 2 c 5 3 d 9 4 select series in "Rows" "stacy05" wrote: HI!! I think I am thinking too much about this and it is easier than it seems, but I cant figure it out! hopefully someone can help. So I need to create a chart with 2 column...plan vs. actual. But I need each of these bar columns to be separted by percentages of the categories that make them up. EX: I need to make a comparison on how big of a percentage the Labor part of the Budget was when they planned and how it differs from the actual execution. Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine Clustered Column Bar charts and Stacked column bar charts | Charts and Charting in Excel | |||
Matching the colors Column Charts and Pie Charts | Charts and Charting in Excel | |||
Charts with 2 different pieces of data and a displayed percentage difference | Excel Discussion (Misc queries) | |||
Percentage rounding error in charts | Excel Discussion (Misc queries) | |||
Can I add values, labels and percentage for pie charts? | Charts and Charting in Excel |