software

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
quot;auto shapesquot;, 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: www.excelforum.com/member.php...oamp;userid=29846
View this thread: www.excelforum.com/showthread...hreadid=495493Unfortunately, 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 gt;,says...
gt;
gt; Hi all,
gt; I'm a newbie to this forum. I tried using the search function, but
gt; could not get it to work for me. Does anyone know if you can use a
gt; connector to connect an arrow from a column to an offset point on a run
gt; chart (when using a dual chart...Column and Line with two axes)? I
gt; tried doing this, but the arrow won't stay connected if I add
gt; additional data (which I am doing being that I'm trending two data
gt; points...patient volume and late charges....each day since 09/01/05).
gt;
gt; I'm trying to avoid having to adjust these arrows every time I add data
gt; for the next day, and being that the columns and run chart points aren't
gt; quot;auto shapesquot;, the connectors won't lock onto them.
gt;
gt; Offsetting the run chart won't work in that the number of days late
gt; varies, so simply sliding the run chart over...which I've done, but
gt; have rejected that approach... isn't an accurate methodology.
gt;
gt; Sorry for the long post...any help is appreciated. Thanks
gt; !
gt;
gt;
gt; --
gt; FrankLP
gt; ------------------------------------------------------------------------
gt; FrankLP's Profile: www.excelforum.com/member.php...oamp;userid=29846
gt; View this thread: www.excelforum.com/showthread...hreadid=495493
gt;
gt;