Keep in mind that by using the excel lib the object name is ... xlapp.something ...
just put that into the formula object...
detlef
_____
Von: Robert Rais [mailto:Robert.Rais@us.yazaki.com]
Gesendet: Donnerstag, 3. Januar 2008 15:20
An: VRF
Betreff: RE: [vrf] Add new data series to a existing chart with excel library
James,
Use the bolded code for adding a new data series to your chart. I used the excel 97 example and modified it to add a second data series. Just change the data location to add the series.
Robert
sheet.ChartObjects.Add(0,0,420,220);
sheet.ChartObjects(1).Activate;
book.ActiveChart.ChartType=xlLineMarkers;
book.ActiveChart.SetSourceData(ChartRange, xlColumns);
book.ActiveChart.SeriesCollection(1).Delete;
book.ActiveChart.SeriesCollection.NewSeries();
book.ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R20C1:R50C1";
book.ActiveChart.SeriesCollection(2).Values = "=Sheet1!R20C1:R50C1";
_____
From: James Zhang [mailto:James.Zhang@rfsworld.com]
Sent: Tuesday, January 01, 2008 9:17 PM
To: VRF
Subject: [vrf] Add new data series to a existing chart with excel library
Hi all!
I'm using VEE7.5 and what i'd like to do is to add some new data series to a predefined chart in a excel file by using the excel library, it seems there's no such function included in the library, can someone guide me on how to realize this?
Thanks!
--- You are currently subscribed to vrf as: Robert.Rais@us.yazaki.com To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body. 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". Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive". Search the Agilent vrf archive at "http://vee.engineering.agilent.com".
---
You are currently subscribed to vrf as: Detlef.Baranski@pilkington.de
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
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".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".
Der Inhalt dieser E-Mail (inkl. aller Anlagen) ist vertraulich und ausschließlich für den Adressaten bestimmt. Jede Art der Verbreitung, Nutzung oder Vervielfältigung ist untersagt. Sollten Sie diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und löschen die E-Mail.
Unternehmensangaben der Gesellschaften mit Sitz in Deutschland:
Pilkington Holding GmbH, Haydnstraße 19, 45884 Gelsenkirchen
Sitz: Gelsenkirchen, Amtsgericht Gelsenkirchen HRB 8997
Geschäftsführung: Jochen Settelmayer (Vorsitz), Dr. Clemens Miller, Thomas Kretschmann, Robert Hales
Vorsitzender des Aufsichtsrates: Dr. Axel Wiesener
Pilkington Deutschland AG, Haydnstraße 19, 45884 Gelsenkirchen
Sitz: Gelsenkirchen, Amtsgericht Gelsenkirchen HRB 2707
Vorstand: Dr. Clemens Miller, Jochen Settelmayer
Vorsitzender des Aufsichtsrates: Dr. Axel Wiesener
Pilkington Automotive Deutschland GmbH, Otto-Seeling-Straße 7, 58455 Witten
Sitz: Witten, Amtsgericht Bochum HRB 8443
Geschäftsführung: Thomas Kretschmann
Vorsitzender des Aufsichtsrates: Jochen Settelmayer
Bauglasindustrie GmbH, Hüttenstraße 33, 66839 Schmelz / Saar
Sitz: Schmelz / Saar, Amtsgericht Saarbrücken HRB 52020
Geschäftsführung: Manfred Ebbers
---
You are currently subscribed to vrf as: ming_meng@agilent.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
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".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".
just put that into the formula object...
detlef
_____
Von: Robert Rais [mailto:Robert.Rais@us.yazaki.com]
Gesendet: Donnerstag, 3. Januar 2008 15:20
An: VRF
Betreff: RE: [vrf] Add new data series to a existing chart with excel library
James,
Use the bolded code for adding a new data series to your chart. I used the excel 97 example and modified it to add a second data series. Just change the data location to add the series.
Robert
sheet.ChartObjects.Add(0,0,420,220);
sheet.ChartObjects(1).Activate;
book.ActiveChart.ChartType=xlLineMarkers;
book.ActiveChart.SetSourceData(ChartRange, xlColumns);
book.ActiveChart.SeriesCollection(1).Delete;
book.ActiveChart.SeriesCollection.NewSeries();
book.ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R20C1:R50C1";
book.ActiveChart.SeriesCollection(2).Values = "=Sheet1!R20C1:R50C1";
_____
From: James Zhang [mailto:James.Zhang@rfsworld.com]
Sent: Tuesday, January 01, 2008 9:17 PM
To: VRF
Subject: [vrf] Add new data series to a existing chart with excel library
Hi all!
I'm using VEE7.5 and what i'd like to do is to add some new data series to a predefined chart in a excel file by using the excel library, it seems there's no such function included in the library, can someone guide me on how to realize this?
Thanks!
--- You are currently subscribed to vrf as: Robert.Rais@us.yazaki.com To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body. 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". Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive". Search the Agilent vrf archive at "http://vee.engineering.agilent.com".
---
You are currently subscribed to vrf as: Detlef.Baranski@pilkington.de
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
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".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".
Der Inhalt dieser E-Mail (inkl. aller Anlagen) ist vertraulich und ausschließlich für den Adressaten bestimmt. Jede Art der Verbreitung, Nutzung oder Vervielfältigung ist untersagt. Sollten Sie diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und löschen die E-Mail.
Unternehmensangaben der Gesellschaften mit Sitz in Deutschland:
Pilkington Holding GmbH, Haydnstraße 19, 45884 Gelsenkirchen
Sitz: Gelsenkirchen, Amtsgericht Gelsenkirchen HRB 8997
Geschäftsführung: Jochen Settelmayer (Vorsitz), Dr. Clemens Miller, Thomas Kretschmann, Robert Hales
Vorsitzender des Aufsichtsrates: Dr. Axel Wiesener
Pilkington Deutschland AG, Haydnstraße 19, 45884 Gelsenkirchen
Sitz: Gelsenkirchen, Amtsgericht Gelsenkirchen HRB 2707
Vorstand: Dr. Clemens Miller, Jochen Settelmayer
Vorsitzender des Aufsichtsrates: Dr. Axel Wiesener
Pilkington Automotive Deutschland GmbH, Otto-Seeling-Straße 7, 58455 Witten
Sitz: Witten, Amtsgericht Bochum HRB 8443
Geschäftsführung: Thomas Kretschmann
Vorsitzender des Aufsichtsrates: Jochen Settelmayer
Bauglasindustrie GmbH, Hüttenstraße 33, 66839 Schmelz / Saar
Sitz: Schmelz / Saar, Amtsgericht Saarbrücken HRB 52020
Geschäftsführung: Manfred Ebbers
---
You are currently subscribed to vrf as: ming_meng@agilent.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
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".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".