Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi - I'm stuck
I have a set of data like this A M J J A S O N D Contractor Fault 1 1 2 3 4 2 Contractor Fault 2 2 1 4 6 8 Worker Fault 1 9 1 3 7 2 Worker Fault 2 0 3 4 2 1 I would like to put it on one graph using 2 stacked columns per month, 1 for contractor, 1 for worker. I would like each stacked column to show the type of faults as well. Try as I might I can't do it, I can get 4 columns or 1 stacked column for each month, but not 2. Any tips?? Cheers |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Your problem is clearer when viewing through reply window.
It's still not clear whether the data you supply is the number of instances or the fault type - either way you won't be able to chart it without both sets of data. Unless I'm missing something. "noy" wrote: Hi - I'm stuck I have a set of data like this A M J J A S O N D Contractor Fault 1 1 2 3 4 2 Contractor Fault 2 2 1 4 6 8 Worker Fault 1 9 1 3 7 2 Worker Fault 2 0 3 4 2 1 I would like to put it on one graph using 2 stacked columns per month, 1 for contractor, 1 for worker. I would like each stacked column to show the type of faults as well. Try as I might I can't do it, I can get 4 columns or 1 stacked column for each month, but not 2. Any tips?? Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Are there better GRAPHS within EXCEL or Add-on graphs? | Charts and Charting in Excel | |||
Automatic Graphs/ Dynamic Graphs | Charts and Charting in Excel | |||
Graphs | Excel Worksheet Functions | |||
GRAPHS PLEASE HEL | Excel Discussion (Misc queries) | |||
Line Graphs and Bar Graphs | Excel Discussion (Misc queries) |