LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Sandi
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combination stock and scatter chart ArtZ Charts and Charting in Excel 1 January 8th 06 07:59 PM
Scatter chart without numerical values Fred Geiger Charts and Charting in Excel 3 September 26th 05 08:02 AM
Line chart or scatter chart?? rmellison Excel Discussion (Misc queries) 0 September 9th 05 10:31 AM
Line chart or scatter chart?? rmellison Excel Discussion (Misc queries) 2 September 7th 05 12:04 PM
Scatter Chart Axis as text in C# Web appl Pavr1 Charts and Charting in Excel 1 March 31st 05 05:28 AM


All times are GMT +1. The time now is 05:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"