rjbinney
Active Member
- Joined
- Dec 20, 2010
- Messages
- 292
- Office Version
- 365
- Platform
- Windows
Another "should be simple but I'm feeling stuck" graph question.
I am trying to graphically show how an asset is being utilized. Every hour of every day is accounted for. For simplicity's sake, the asset can be used as "A", "B", "C", or "D".
I'd like to show a graph with a Column for each Day, with the Y-Axis each Hour of the Day. And I'd like each plot point to be an equally-sized box, color-coded to A, B, C, or D.
Right now my data structured so column A is "Day of the Week", column B is "Hour of the Day", and column C is "Category". Sample data is below what I think I'd like my chart to look like.
Open to ideas! I am truly stumped.
I am trying to graphically show how an asset is being utilized. Every hour of every day is accounted for. For simplicity's sake, the asset can be used as "A", "B", "C", or "D".
I'd like to show a graph with a Column for each Day, with the Y-Axis each Hour of the Day. And I'd like each plot point to be an equally-sized box, color-coded to A, B, C, or D.
Right now my data structured so column A is "Day of the Week", column B is "Hour of the Day", and column C is "Category". Sample data is below what I think I'd like my chart to look like.
Open to ideas! I am truly stumped.
MrExcel | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Day | Hour | Category | ||
2 | 1 | 1 | C | ||
3 | 1 | 2 | A | ||
4 | 1 | 3 | A | ||
5 | 1 | 4 | D | ||
6 | 1 | 5 | A | ||
7 | 1 | 6 | A | ||
8 | 1 | 7 | A | ||
9 | 1 | 8 | B | ||
10 | 2 | 1 | A | ||
11 | 2 | 2 | C | ||
12 | 2 | 3 | C | ||
13 | 2 | 4 | D | ||
14 | 2 | 5 | A | ||
15 | 2 | 6 | A | ||
16 | 2 | 7 | D | ||
17 | 2 | 8 | D | ||
18 | 3 | 1 | B | ||
19 | 3 | 2 | B | ||
20 | 3 | 3 | A | ||
21 | 3 | 4 | D | ||
22 | 3 | 5 | B | ||
23 | 3 | 6 | A | ||
24 | 3 | 7 | A | ||
25 | 3 | 8 | B | ||
Sample Data |