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 |
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 |
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