ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   2D graph with label (https://www.excelbanter.com/excel-discussion-misc-queries/180134-2d-graph-label.html)

[email protected]

2D graph with label
 
I'm trying to produce the following graph

Program Name Long Leverage Gross
M1 23.06% 80.00%
M2 23.86% 96.67%
M3 25.27% 134.00%
M4 25.44% 118.30%
M5 27.87% 128.85%
M6 28.88% 132.00%
M7 32.33% 247.10%
M8 36.46% 152.60%
M9 42.50% 45.61%
M10 45.72% 160.25%


I want Long on the X axis, Leverage Gross on the Y axis and for each
point (X,Y) I want the Program Name tab next to it. Everything in a
scatter plot.

Anybody knows how to do that?

Thank you much.

Earl Kiosterud

2D graph with label
 
Kathy,

Make the scatter graph in the usual way, and get Rob Bovey's XY chart labeler, free, from
appspro.com.

--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
wrote in message
...
I'm trying to produce the following graph

Program Name Long Leverage Gross
M1 23.06% 80.00%
M2 23.86% 96.67%
M3 25.27% 134.00%
M4 25.44% 118.30%
M5 27.87% 128.85%
M6 28.88% 132.00%
M7 32.33% 247.10%
M8 36.46% 152.60%
M9 42.50% 45.61%
M10 45.72% 160.25%


I want Long on the X axis, Leverage Gross on the Y axis and for each
point (X,Y) I want the Program Name tab next to it. Everything in a
scatter plot.

Anybody knows how to do that?

Thank you much.





All times are GMT +1. The time now is 02:20 AM.

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