My data set is as follows:

TABLE FILE CAR
SUM PCT.RETAIL_COST DEALER_COST
ACROSS COUNTRY
BY CAR
END

How do I graph using a bar dual axis stacked where the 1st Y-axis (bar) is across country, by car, pct.retail_cost.

The 2nd y-axis (line) is across country, tot.dealer_cost

It always break down my line graph across country, by car, tot.dealer_cost

So, for ENGLAND, I would have a stacked bar for pct.rc for jag (49),jensen (39) and triumph (11) and a line graph for dc for 37,853

Dan

You will need to play with this a bit, but my line is item 5. You may have to calculate the tot.dealer_cost and pct.retail_cost in a preprocessing step.
code
setSeriesType(0,1);
setLegendDisplay(true);
setLegendMarkerPosition(0);
setMarkerDisplay(true);
setUseSeriesShapes(false);
setConnectLineMarkers(true);
setConnectScatterMarkers(true);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(4);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setSeriesType(0,1);
setAxisAssignment(1,0);
setSeriesType(1,1);
setAxisAssignment(4,1);
setSeriesType(4,2);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),1);

setDataTextDisplay(true);
setCustomDataText(getSeries(0), true);
setCustomDataText(getSeries(1), true);
setCustomDataText(getSeries(2), true);
setCustomDataText(getSeries(3), true);
setCustomDataText(getSeries(4), true);
setCustomDataText(getSeries(5), true);
setDisplay(getDataText(0), false);
setDisplay(getDataText(1), false);
setDisplay(getDataText(2), false);
setDisplay(getDataText(3), false);
setDisplay(getDataText(4), false);
-* I think this is the line --****
setDisplay(getDataText(5), true);
setTextFormatPreset(getDataText(2),2);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setTextJustHoriz(getO1Label(),2);
setFontSizeAbsolute(getO1Label(),true);
setFontSize(getO1Label(),12);
setTextRotation(getO1Label(),3);
setTextWrap(getO1Label(),false);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
ENDSTYLE
\code

Thanks PBrightwell. Let me see if I can pre-process those fields.

Here's what I got. I got the Y1 data correct but the Y2 is not. Any ideas?

GRAPH FILE CAR
SUM PCT.RETAIL_COST TOT.DEALER_COST
ACROSS COUNTRY
BY CAR
ON GRAPH SET LOOKGRAPH VBRSTK2
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET GRMERGE ON
ON GRAPH PCHOLD FORMAT JPEG
ON GRAPH SET GRAPHSTYLE *
setGridStep(getY1MajorGrid(),20.0);
setGridStep(getY2MajorGrid(),20000.0);
setBorderColor(getX1MinorGrid(),new Color(133,133,133));
setBorderColor(getY1MinorGrid(),new Color(133,133,133));
setFillType(getColorByHeight(),2);
setGradientDirection(getColorByHeight(),1);
setGradientNumPins(getColorByHeight(),2);
setGradientPinPosition(getColorByHeight(),0.0,0);
setGradientPinLeftColor(getColorByHeight(),new Color(255,255,255),0);
setGradientPinRightColor(getColorByHeight(),new Color(0,0,255),0);
setGradientPinPosition(getColorByHeight(),1.0,1);
setGradientPinLeftColor(getColorByHeight(),new Color(255,0,0),1);
setGradientPinRightColor(getColorByHeight(),new Color(255,255,255),1);
setScaleMax(getY1Axis(),120.0);
setScaleMax(getY2Axis(),120000.0);
setScaleMin(getY2Axis(),0.0);
setAxisAssignment(getSeries(2),0);
setAxisAssignment(getSeries(3),1);
setSeriesType(getSeries(3),2);
setAxisAssignment(getSeries(4),0);
setAxisAssignment(getSeries(5),1);
setSeriesType(getSeries(5),2);
setAxisAssignment(getSeries(6),0);
setAxisAssignment(getSeries(7),1);
setSeriesType(getSeries(7),2);
setAxisAssignment(getSeries(8),0);
setAxisAssignment(getSeries(9),1);
setSeriesType(getSeries(9),2);
setAxisAssignment(getSeries(10),0);
setAxisAssignment(getSeries(11),1);
setSeriesType(getSeries(11),2);
setAxisAssignment(getSeries(12),0);
setAxisAssignment(getSeries(13),1);
setSeriesType(getSeries(13),2);
setAxisAssignment(getSeries(14),0);
setAxisAssignment(getSeries(15),1);
setSeriesType(getSeries(15),2);
setAxisAssignment(getSeries(16),0);
setAxisAssignment(getSeries(17),1);
setSeriesType(getSeries(17),2);
setAxisAssignment(getSeries(18),0);
setAxisAssignment(getSeries(19),1);
setSeriesType(getSeries(19),2);
setMarkerDisplay(true);
setConnectLineMarkers(true);
setConnectScatterMarkers(true);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setSeriesType(0,1);
setAxisAssignment(1,1);
setSeriesType(1,2);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setY2LabelDisplay(true);
setY2AxisSide(1);
setY2MajorGridDisplay(true);
setY2MajorGridStyle(0);
setY2MinorGridDisplay(false);
setTextFormatPreset(getY2Label(),-1);
setTextFormatPattern(getY2Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setLegendTextAutofit(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setO1LabelAutofit(true);
setPlace(false);
ENDSTYLE
ON GRAPH SET STYLE *
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
ENDSTYLE
END