Excel/Graphing - Time vs. usage (y/n) graph

Oh great mefites. How do I create a graph that has on the X axis discrete items, such as "LIGHT A, LIGHT B, LIGHT C", and on the Y axis a timescale.

Basically I would like to be able to visually share usage patterns of various devices that are either being used, or not used.

The result would look something like this.

This would be relevant for many Y/N items, such as "what do the usage patterns of my 40 workstations at my business look like", or "what lights are on", or "what ports are on/off on my switch during the day".

I specifically want to be able to individually review items as show, I do not want an additive line graph/bar graph that one cannot make assumptions by looking horizontally.

Any tool is fair game.

Original text: Timescale display in Excel

Similar Posts:

Leave a Reply