ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Adding shapes to xy scatter charts (https://www.excelbanter.com/excel-programming/342843-adding-shapes-xy-scatter-charts.html)

Richw

Adding shapes to xy scatter charts
 

:confused:
Does anyone know how/if one can relate page coordinates (adding a line
for instance) with a scatter XY log/log chart coordinates? I generate
XY log/log charts automatically (VBA) but sometimes need to add a line
with arrow pointing to a point on the chart to indicate (with a text
box) that the point actually represents more than one sample. Any help
is appreciated, thanks in advance.

Rich


--
Richw
------------------------------------------------------------------------
Richw's Profile: http://www.excelforum.com/member.php...o&userid=28118
View this thread: http://www.excelforum.com/showthread...hreadid=476250


MrShorty[_25_]

Adding shapes to xy scatter charts
 

View-toolbars- and pull up the drawing toolbar. The drawing toolbar
has tools for adding arrows and text boxes.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=476250


Richw

Adding shapes to xy scatter charts
 

Sorry! :eek:
Forgot to say I want to do this programmatically. I know you can add
line programmatically using page coordinates, but how do you relat
these to chart coordinates?

Ric

--
Rich
-----------------------------------------------------------------------
Richw's Profile: http://www.excelforum.com/member.php...fo&userid=2811
View this thread: http://www.excelforum.com/showthread.php?threadid=47625



All times are GMT +1. The time now is 10:20 PM.

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