Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / February 2006

Tip: Looking for answers? Try searching our database.

xy Scatter chart

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sandi - 27 Feb 2006 16:34 GMT
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?

Signature

Sandi Gardner

Jerry W. Lewis - 27 Feb 2006 18:40 GMT
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

> I will try to explain this to the best of my knowledge:
>
[quoted text clipped - 15 lines]
> will be appreciated.  The person that wants this chart wanted to know if
> Excel has the capabilities of using Polar Notations or Carteasan Coordinates?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.