Graph Two Groups in Same Graph?

[shelby55]

Hi

I am using Crystal 9.0 reporting on Access 2003 data.

I am creating physician profiles and want to show each physician's data but also show how that relates to their doctor service in a graph.

In table format, the data has Group A = Doctor Service and Group B = Physician (individual). Within Group 2 I have the following code to show the Doctor Service average length of stay:

whileprintingrecords;
numbervar dalos1;
if {@DDays1}>0 then dalos1:= {@DDays1}/{@DCases1}

DDays1 =

whileprintingrecords;
shared numbervar ddays1;
ddays1:=Sum ({@Days1}, {@Programs})/DistinctCount ({@Doc1}, {@Programs})

DCases1 =

whileprintingrecords;

shared numbervar dcases1;
dcases1:=Sum ({@Cases1}, {@Programs})/DistinctCount ({@Doc1}, {@Programs})

Is there anyway to graph Doctor Service and Doctor information on the same graph? Thanks.

 

[BTSTeam]

In the Chart Options under Axes you can choose to display two sets of data (if you have two data value sources in the Data area of the Chart Expert) and have separate Axes scales for each.

Is this the sort of thing that you need?