If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
xy Scatter chart
I will try to explain this to the best of my knowledge:
I have a spreadsheet with some information that is set up like this: Example Risk Impact Probability Director Trls Med 3 1 Wrong Trips High 4 3 Upgrade JAX Low 1 1 These numbers are generated from a series of questions that determine wether the risk is a high, med, or low factor. So there is really no way of knowing what numbers determines a Low, Med, or High Risk The numbers will never go higher than a 4 and lower than a 1. Adding them up the highest number you can get is an 8. I am trying to graph these there where the high numbers will be at the top, the medium in the middle and the lower in at the bottom of the chart. I think there will have to be an IF function in here of some kind but am at a loss of where to even start or if this even makes sense. Any help will be appreciated. The person that wants this chart wanted to know if Excel has the capabilities of using Polar Notations or Carteasan Coordinates? -- Sandi Gardner |
#2
|
|||
|
|||
xy Scatter chart
Excel natively plots using Cartesian coordinates. However, you can fake
polar coordinates http://www.andypope.info/charts/polarplot.htm For risk analysis, I am more used to seeing risk and probability multiplied rather than added, but risk is usaually assessed on a broader scale. For instance, you might have several aspects of quality, such as - business continuity - product quality - regulatory impact each on a numeric scale, where you would add the risk factors together then multiply by probability of occurrance. As for where to place the boundaries for Low, Med, & High risk, I would agree that your low and high risk examples are correctly categorized; but I question the medium risk example, since its probability of occurrance is at the lowest possible level. Jerry "Sandi" wrote: I will try to explain this to the best of my knowledge: I have a spreadsheet with some information that is set up like this: Example Risk Impact Probability Director Trls Med 3 1 Wrong Trips High 4 3 Upgrade JAX Low 1 1 These numbers are generated from a series of questions that determine wether the risk is a high, med, or low factor. So there is really no way of knowing what numbers determines a Low, Med, or High Risk The numbers will never go higher than a 4 and lower than a 1. Adding them up the highest number you can get is an 8. I am trying to graph these there where the high numbers will be at the top, the medium in the middle and the lower in at the bottom of the chart. I think there will have to be an IF function in here of some kind but am at a loss of where to even start or if this even makes sense. Any help will be appreciated. The person that wants this chart wanted to know if Excel has the capabilities of using Polar Notations or Carteasan Coordinates? -- Sandi Gardner |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
mix chart types | Ken Murray | Powerpoint | 7 | April 28th, 2006 02:50 AM |
scatter chart insists on plotting as a line chart | Knows too little | New Users | 0 | March 11th, 2005 06:37 PM |
'Closing' chart window *and* removing chart using VBA | Marc R. Bertrand | Charts and Charting | 7 | December 17th, 2003 04:30 PM |
Help ! Scatter Chart plots wrongly ! | Jon Peltier | Charts and Charting | 2 | November 19th, 2003 12:57 PM |
Styles for chart | Debra Dalgleish | Charts and Charting | 1 | October 3rd, 2003 12:27 PM |