Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can you help me chart this data?
I cannot find a way to chart this data - can anyone make suggestions: The
data represents each of our servers by component ID, age, End of service life, failures, MTBF, Maint cost and business unit. The corresponding values are scored - the goal is to identify assets to be tech refreshed by thier score, ie. if a component has a lot of failures and it is really old, we may decide to tech refresh. ID Age EOSL Failures MTBF Maint Cost BU C102204 7 12/31/2010 4 688 £5,460 Corporate Score 3 10 3 10 10 C194606 5 12/31/2010 25 4 £5,460 GMS score 9 10 10 9 10 6 76 C194607 5 12/31/2010 4 52 5,460 R&D score 9 15 10 6 5 6 C194608 5 12/31/2010 Standard 3 44 £5,460 Corporate score 3 10 10 6 10 12 87 C28115 9 12/31/2010 Standard 135 33 £5,460 Corporate score 6 10 5 9 10 6 82 C28116 9 12/31/2010 Standard 27 169 £5,460 Corporate score 9 5 10 9 5 6 78 C28117 9 12/31/2010 Standard 7 569 £5,460 Corporate score 9 15 15 9 15 18 107 C28118 9 12/31/2010 Standard 182 23 £5,460 Corporate score 3 15 15 9 10 6 87 C28120 9 12/31/2010 Standard 16 226 £5,460 Corporate score 6 15 10 6 15 12 105 C28122 9 12/31/2010 Standard 6 589 £5,460 Corporate score 3 10 10 3 15 12 95 C28124 9 12/31/2010 Standard 4 445 £5,460 Corporate score 9 10 10 9 10 6 76 C28125 9 12/31/2010 Standard 9 361 £5,460 Corporate score 9 10 10 9 10 6 76 C28126 9 12/31/2010 Standard 20 216 £5,460 Corporate score 9 10 10 9 10 6 76 -- Patti |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can you help me chart this data?
If I'm reading this correctly, each system has 2 rows of information, with
the 'scores' being on the row below various values for the system. I'd rearrange the data so that the scores are on the same row with the other system information. That should make it easy to chart it all out. Also, I notice that it appears some systems have 5 scores, some 6 and some 7. Being consistent in providing all scores for each system will help you also. "Patti W" wrote: I cannot find a way to chart this data - can anyone make suggestions: The data represents each of our servers by component ID, age, End of service life, failures, MTBF, Maint cost and business unit. The corresponding values are scored - the goal is to identify assets to be tech refreshed by thier score, ie. if a component has a lot of failures and it is really old, we may decide to tech refresh. ID Age EOSL Failures MTBF Maint Cost BU C102204 7 12/31/2010 4 688 £5,460 Corporate Score 3 10 3 10 10 C194606 5 12/31/2010 25 4 £5,460 GMS score 9 10 10 9 10 6 76 C194607 5 12/31/2010 4 52 5,460 R&D score 9 15 10 6 5 6 C194608 5 12/31/2010 Standard 3 44 £5,460 Corporate score 3 10 10 6 10 12 87 C28115 9 12/31/2010 Standard 135 33 £5,460 Corporate score 6 10 5 9 10 6 82 C28116 9 12/31/2010 Standard 27 169 £5,460 Corporate score 9 5 10 9 5 6 78 C28117 9 12/31/2010 Standard 7 569 £5,460 Corporate score 9 15 15 9 15 18 107 C28118 9 12/31/2010 Standard 182 23 £5,460 Corporate score 3 15 15 9 10 6 87 C28120 9 12/31/2010 Standard 16 226 £5,460 Corporate score 6 15 10 6 15 12 105 C28122 9 12/31/2010 Standard 6 589 £5,460 Corporate score 3 10 10 3 15 12 95 C28124 9 12/31/2010 Standard 4 445 £5,460 Corporate score 9 10 10 9 10 6 76 C28125 9 12/31/2010 Standard 9 361 £5,460 Corporate score 9 10 10 9 10 6 76 C28126 9 12/31/2010 Standard 20 216 £5,460 Corporate score 9 10 10 9 10 6 76 -- Patti |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart empty with new data in the dynamic range chart. | Excel Discussion (Misc queries) | |||
chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
How do you link chart source data when you copy the chart? | Charts and Charting in Excel | |||
Resizing chart because of refreshing Chart Data through a query | Charts and Charting in Excel | |||
Chart data file lost - need to re-create from chart? | Charts and Charting in Excel |