Greetings,
I am stuck on this one.
I have a table:
Date Hour Attribute Value
1/1/2016 1 A 0
1/1/2016 1 B 1
1/2/2016 0 C 1
1/3/2016 23 A 1
...
I need to produce a chart that shows dates on the Y axis and hour on the X axis and the field of data for the bar should be a 1 or a 0 (So, for A with a 1 value for hours 1-6, the bar would show solid) and then show nothing when the value is 0. The chart would show 3 bars, one for each attribute.
Can anyone please point me in the right direction or have any ideas?
Thanks!
Ed
I am stuck on this one.
I have a table:
Date Hour Attribute Value
1/1/2016 1 A 0
1/1/2016 1 B 1
1/2/2016 0 C 1
1/3/2016 23 A 1
...
I need to produce a chart that shows dates on the Y axis and hour on the X axis and the field of data for the bar should be a 1 or a 0 (So, for A with a 1 value for hours 1-6, the bar would show solid) and then show nothing when the value is 0. The chart would show 3 bars, one for each attribute.
Can anyone please point me in the right direction or have any ideas?
Thanks!
Ed