ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to create 4 Quadrant Chart in Excel 2003? (https://www.excelbanter.com/charts-charting-excel/195112-how-create-4-quadrant-chart-excel-2003-a.html)

ROHIT

How to create 4 Quadrant Chart in Excel 2003?
 
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

Bernard Liengme

How to create 4 Quadrant Chart in Excel 2003?
 
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" wrote in message
...
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





All times are GMT +1. The time now is 10:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com