Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic DOORS (steve huntington)
Decrease font size
Increase font size
Topic Title: Problem in Creating Bubble Chart
Topic Summary:
Created On: 7-Jul-2006 10:30
Status: Post and Reply
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Quick Reply Quick Reply
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 7-Jul-2006 10:30
User is offline View Users Profile Print this message


Jayaprakash Lingamaneni

Posts: 20
Joined: 23-Jun-2006

Hi All
I want to create a Bubble chart from DXL code
i can able to create the chart
but, problem is i am not able to set the source to that bubbles

following is the VB code

    Charts.Add
    ActiveChart.ChartType = xlBubble
    ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("E7")
    ActiveChart.SeriesCollection.NewSeries 

    ActiveChart.SeriesCollection(1).XValues = "=Sheet2!R1C2"
    ActiveChart.SeriesCollection(1).Values = "=Sheet2!R1C3"
    ActiveChart.SeriesCollection(1).Name = "=Sheet2!R1C1"
    ActiveChart.SeriesCollection(1).BubbleSizes = "=Sheet2!R1C4" 

    ActiveChart.SeriesCollection(2).XValues = "=Sheet2!R1C2"
    ActiveChart.SeriesCollection(2).Values = "=Sheet2!R1C3"
    ActiveChart.SeriesCollection(2).Name = "=Sheet2!R1C1"
    ActiveChart.SeriesCollection(2).BubbleSizes = "=Sheet2!R1C4"

i am getting problem at passing index to SeriesCollection Property
How can i pass the index to SeriesCollection Property

Please give me any suggestion

Thanks is advance

Regards

Jaya Prakaksh

Report this to a Moderator Report this to a Moderator
 10-Jul-2006 09:06
User is offline View Users Profile Print this message


Reik Schroeder

Posts: 361
Joined: 28-Jul-2003

Hi Jaya,

I do not know exactly wherefore you will use this charts, but in past I used Excel template files to define the style of charts.

Some month ago I've created a script to generate an report with some charts in Word. Therefore I used a word template to define the styles in the document.
The charts where created based on a set of Excel template files, which already containing the chart. So you can easily manage the style of chart in template and use doors only to update the information used in the charts.
After creation of one chart it was be copied via clipboard into word document.

May be this solution is useable for your work too ?!

It will keep you away a little bit from dealing with the OLE/VBA stuff

Greetings
Reik Schröder

-------------------------
Evosoft GmbH
for Siemens Industry Sector


Berlin, Germany

Edited: 10-Jul-2006 at 09:16 by Reik Schroeder
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 1 users logged in.
The most users ever online was 15 on 15-Jan-2009 at 16:36.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.