How to create 4 Quadrant Chart in Excel 2003?

R

Rohit

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
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I create a quadrant analysis in excel? 2
How to get 4 positive quadrants in xy scatter graph 1
Four Quadrant Bubble Chart in Excel? 7
Quadrant Chart Sample 2
how do I create a quadrant chart in Excel or PowerPoint? 1
After upgrading to 2003 the scatter charts no longer show data la. 2
able to automatically create a chart in Excel 2
how to create "magic grid" chart with names in it 2

Top