RE: two series in one pie chart

[Software FX]

When you connect a chart to a recordset the default is to use each numerical column as a data series and each record as a value, e.g. a SQL statement that selects 2 columns and returns 12 records will create a chart with 2 series and 12 points on each series.

You can change this behavior by using the DataStyle property to turn on the CHART_DS_TRANSPOSE before the AdoResultset call. This will "transpose" the default behavior by using each record as a data series and each column as a value. if your SQL statement returns two columns and 1 record you will end up with 1 pie chart with two slices (instead of 2 pie charts each one with one slice).

Regards, 

Juan Cegarra 

Software FX, Inc. 

http://support.softwarefx.com 

-----Original Message----- 

From: Nicky Wanderer [ mailto:nzwanderer@telco-gc.com] 

Posted At: Friday, July 28, 2000 5:35 AM 

Posted To: Server 

Conversation: two series in one pie chart 

Subject: two series in one pie chart 

Hi, 

I have a record set containing two pieces of information 'national cost' and 

'international cost' I want them displayed in a single pie chart so you can 

clearly see what % of the total each figure makes, however they keep comming 

up in two seperate pie charts how can I solve this? 

thanks 

Nicky