| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked bars with Single bar alongside
I am trying to create a graphical representation of people's
availability over the coming months. I have 7 people, available for varying numbers of hours each month and details of their current commitments and, by calculation, the shortfall/remaining availability Jan Feb Mar Apr Joe Avail 154 140 154 143 Joe Work 100 165 135 150 Joe Free 54 -25 19 -7 Tom Avail Tom Work Tom Free Kim Avail Kim Work Kim Free .. .. .. .. .. What I would like to create is a chart, showing the Availability in a single bar with the Work and Free (or not) stacked alongside for each person for Jan, then for Feb, then for Mar, then for Apr. If at all possible, with their names as a label, if not then in the legend will do. Can someone point me in the right direction please. I've looked at the suggestion on Stephen Bullen's site (FunChrt4) but couldn't get it to work as I am describing above. Thanks in advance for any help provided Regards Fred |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Stacked bars with Single bar alongside
One reason it might not be working is that you haven't adjusted your data.
You have to stagger the data so the Avail don't stack on the Work and Free points and vice versa. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Fred" wrote in message oups.com... I am trying to create a graphical representation of people's availability over the coming months. I have 7 people, available for varying numbers of hours each month and details of their current commitments and, by calculation, the shortfall/remaining availability Jan Feb Mar Apr Joe Avail 154 140 154 143 Joe Work 100 165 135 150 Joe Free 54 -25 19 -7 Tom Avail Tom Work Tom Free Kim Avail Kim Work Kim Free . . . . . What I would like to create is a chart, showing the Availability in a single bar with the Work and Free (or not) stacked alongside for each person for Jan, then for Feb, then for Mar, then for Apr. If at all possible, with their names as a label, if not then in the legend will do. Can someone point me in the right direction please. I've looked at the suggestion on Stephen Bullen's site (FunChrt4) but couldn't get it to work as I am describing above. Thanks in advance for any help provided Regards Fred |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Stacked bars with Single bar alongside
Thanks Jon, that worked like a charm
regards Fred |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up a chart in Excel with lines and stacked bars? | Charts and Charting in Excel | |||
| How can I display two seperate stacked bars in a graph | Charts and Charting in Excel | |||
| Error bars for a single data point not whole series | Charts and Charting in Excel | |||
| To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel | |||
| How can I create a stacked bar chart with stacked bars side by | Charts and Charting in Excel | |||
Linear Mode
