Hi all,
I'm a newbie to this forum. I tried using the search function, but
could not get it to work for me. Does anyone know if you can use a
connector to connect an arrow from a column to an offset point on a run
chart (when using a dual chart...Column and Line with two axes)? I
tried doing this, but the arrow won't stay connected if I add
additional data (which I am doing being that I'm trending two data
points...patient volume and late charges....each day since 09/01/05).

I'm trying to avoid having to adjust these arrows every time I add data
for the next day, and being that the columns and run chart points aren't
"auto shapes", the connectors won't lock onto them.

Offsetting the run chart won't work in that the number of days late
varies, so simply sliding the run chart over...which I've done, but
have rejected that approach... isn't an accurate methodology.

Sorry for the long post...any help is appreciated. Thanks
!


--
FrankLP
------------------------------------------------------------------------
FrankLP's Profile: http://www.excelforum.com/member.php...o&userid=29846
View this thread: http://www.excelforum.com/showthread...hreadid=495493

Unfortunately, the connectors from the Drawing toolbar don't work with
elements in a chart. It would be real nice if they did, but they don't.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article ,
says...

Hi all,
I'm a newbie to this forum. I tried using the search function, but
could not get it to work for me. Does anyone know if you can use a
connector to connect an arrow from a column to an offset point on a run
chart (when using a dual chart...Column and Line with two axes)? I
tried doing this, but the arrow won't stay connected if I add
additional data (which I am doing being that I'm trending two data
points...patient volume and late charges....each day since 09/01/05).

I'm trying to avoid having to adjust these arrows every time I add data
for the next day, and being that the columns and run chart points aren't
"auto shapes", the connectors won't lock onto them.

Offsetting the run chart won't work in that the number of days late
varies, so simply sliding the run chart over...which I've done, but
have rejected that approach... isn't an accurate methodology.

Sorry for the long post...any help is appreciated. Thanks
!


--
FrankLP
------------------------------------------------------------------------
FrankLP's Profile: http://www.excelforum.com/member.php...o&userid=29846
View this thread: http://www.excelforum.com/showthread...hreadid=495493