Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Data Representation on Graphs
I have set up an excel spreadsheet. The first column shows some Key
Performance Indicators that I have chosen. Next to these I have their status, which is either G (Green), A (Amber) or R (Red) in order of progress on each indicator. These are reviewed on a weekly basis and hence the indicators and their status can be looked at across a period of time. I need a good method of presenting this data. Graphs don't really work as there may be many indicators with the same status and hence the graph becomes difficult to read. I need to create a method by which these indicators and their statuses can be viewed easily. I am open to any suggestions. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing multiple criteria to pull data | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Reference multiple cells in if statement | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) |