Jump to content
Software FX Community

RE: two series in one pie chart

Software FX

Recommended Posts

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).


Juan Cegarra

Software FX, Inc.


-----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


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?



Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...