Graphs
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 |
Graphs
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 |
All times are GMT +1. The time now is 11:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com