AnsweredAssumed Answered

vrf Drawing lines on a Excel chart.

Question asked by gregwale on May 3, 2004
Hamish,

The best advice I can think of for stuff like this is to record an Excel
macro while you draw those lines manually, then you can save the macro and
replay it from a worksheet or translate it into VEE. You will probably need
to edit the macro to handle different data. There are resources on my
website under technical articles for translating VBA into VEE.
Regards,
Greg Wale
www.passtechnologies.com

> -----Original Message-----
> From: Hamish.Begg@Powerware.com [mailto:Hamish.Begg@Powerware.com]
> Sent: Sunday, May 02, 2004 3:50 PM
> Subject: Drawing lines on a Excel chart.
>
> Hi all.
> This is not really a VEE question. It's more of a Excel Macro question.
> However the data was gathered and entered in to an Excel  template by VEE
> and some of you know VB.
>
> Anyway, on some of the charts I have limit lines that I wish to connect a
> vertical line to (at the start of them), which either goes to the top of
> the chart or the bottom.
> Does anyone know how this can be done in VBA, so I can add it to my macro?
>
> Best regards
> Hamish Begg
> Pre-Compliance & Certification
> ------------------------------------
> Powerware, 39 Princess St, PO Box 11-188
> Christchurch 8030, New Zealand
> Phone: (++64) 3 343-3314, Fax: (++64) 3 343-5100
> Email: hamish.begg@powerware.com
> Website: http://www.powerware.com
>
> If you received this in error, please contact the sender and delete the
> material from any computer. Any review, retransmission, dissemination or
> other use of, or taking of any action in reliance upon, this information
> by
> persons or entities other than the intended recipient is prohibited.


---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list,  email "vrf@agilent.com". 
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".

Outcomes