Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up a graph to show a number of different criteria?
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 | |||
Off the chart Graph labels, that don't show up? | Charts and Charting in Excel | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Counting the number of cells meeting conditional formating criteria | Excel Worksheet Functions | |||
how to show row number in cell | Excel Worksheet Functions | |||
Countif using format criteria....not number criteria? | Excel Worksheet Functions |