PC Review


Reply
Thread Tools Rate Thread

How to create 4 Quadrant Chart in Excel 2003?

 
 
Rohit
Guest
Posts: n/a
 
      16th Jul 2008
There are 4 quadrant charts available on net. Similar to that how can we
create 4 quadrant charts in Excel 2003 version?

If X axis represents Risk & Y axis represents returns in financial language,
then if we draw line at center of X axis & Y axis, then four quadrants will
be created with Quadrant details as below;

Bottom Left Quadrant : Low Risk & Low Returns
Top Left Quadrant : Low Risk & High Returns
Top Right Quadrant : High Risk & High Returns
Bottom Right Quadrant : High Risk & Low Returns
 
Reply With Quote
 
 
 
 
Bernard Liengme
Guest
Posts: n/a
 
      16th Jul 2008
Top right: x and y are positive
Top left: x is negative; y positive
Bottom left, x and y are negative
Bottom right; y is negative, x positive
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Rohit" <(E-Mail Removed)> wrote in message
news:11F78209-151E-4FB2-ADFC-(E-Mail Removed)...
> There are 4 quadrant charts available on net. Similar to that how can we
> create 4 quadrant charts in Excel 2003 version?
>
> If X axis represents Risk & Y axis represents returns in financial
> language,
> then if we draw line at center of X axis & Y axis, then four quadrants
> will
> be created with Quadrant details as below;
>
> Bottom Left Quadrant : Low Risk & Low Returns
> Top Left Quadrant : Low Risk & High Returns
> Top Right Quadrant : High Risk & High Returns
> Bottom Right Quadrant : High Risk & Low Returns



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a quadrant analysis in excel? BH185002 Microsoft Excel Charting 2 17th Feb 2008 05:20 PM
how do I create a magic quadrant in Excel =?Utf-8?B?SmltVw==?= Microsoft Excel Charting 1 25th Oct 2007 03:22 PM
Four Quadrant Bubble Chart in Excel? aww91@yahoo.com Microsoft Excel Charting 7 20th Sep 2006 05:49 PM
how can I make a quadrant analysis chart using excel =?Utf-8?B?c2Vhbg==?= Microsoft Excel Charting 1 19th Sep 2005 01:30 PM
how do I create a quadrant chart in Excel or PowerPoint? =?Utf-8?B?VGF2bw==?= Microsoft Excel Charting 1 11th Mar 2005 12:11 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:01 PM.