AnsweredAssumed Answered

vrf Add new data series to a existing chart with excel library

Question asked by VRFuser on Jan 3, 2008
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: 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".  

Outcomes