How to chart an item's status with cumulative color codes over time with updates added every 3 minutes

jfq722

New Member
Joined
Apr 24, 2014
Messages
2
Hi all,
I'd like to know what you all think is best way (specific details not required) to show the status of a given item over time as 3 minute snapshots.
A color slot (Yellow, White, Green, Red) will be added to each interface every 3 minutes.

Interace_1 YWWWWGGGGGGGGGGGGRRGGGGGGGGYWWWW

Interface_2 WWWWWWWWWWGGGGYYYYYYYYRRWWWWWWW

0 1 2 3...…...hours 0-23 on X axis (updates every 3 minutes)


I'd like a chart based solution as opposed to just coloring cells.
Would just adding a series for each 3 minute update to each graph accomplish it?
I also assume each interface would have its own graph?
Thanks!
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Watch MrExcel Video

Forum statistics

Threads
1,108,491
Messages
5,523,255
Members
409,506
Latest member
reneekeane

This Week's Hot Topics

Top