Hi, I have the dual axis graph below. Two questions:
- Is there a way to add a goal line of, say, 55.1% that would display as a line across the graph?
- I can't get the % to display for the Y2 Axis or Y2 Data Points. If I do, it converts the Y2 Axis Numbers from 54.8 to 548%.

Thanks in advance for any ideas you might have!

  

APP PREPENDPATH IBISAMP
-*
-* ================================================================================
-* Move the data from SQLOUT to MYSQL which can be read into variables
-* ================================================================================
TABLE FILE CAR
PRINT
	COMPUTE D9MONTH/A12 = COUNTRY;
	COMPUTE D9PROD1/D12.0 = DEALER_COST;
	COMPUTE D9DROS1/D12.0 = RETAIL_COST;
ON TABLE HOLD AS MELTSUMM0401 FORMAT FOCUS
END
-*
-* ====================================================================================================
-* Display Graph
-* ====================================================================================================
GRAPH FILE MELTSUMM0401
SUM D9PROD1 AS 'Lbs Melted' D9DROS1 AS 'Lbs Dross' COMPUTE C9PCT/D12.2= D9DROS1 * 100 / ( D9DROS1 + D9PROD1 ); AS 'Dross Pct'
ACROSS D9MONTH AS 'Month'
FOOTING
"Total dross lbs from central melt and holding furnaces, oily scrap, sows, turnings, and painted/assembled  "
ON GRAPH SET LOOKGRAPH VBRSTK2
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB ON
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setY1MajorGridStepAuto(false);
setY1MajorGridStep(2);
setY2MajorGridStepAuto(false);
setY2MajorGridStep(2);
setDisplay(getDataText(0), false);
setDisplay(getDataText(1), false);
setDisplay(getDataText(2), true);
setStackedDataValueSum(false);
setTextFormatPreset(getY1Label(), -1);
setTextFormatPattern(getY1Label(),"#,###.##");
setTextFormatPreset(getY2Label(), -1);
setTextFormatPattern(getY2Label(),"#.##");
setMarkerDisplay(true);
setConnectLineMarkers(true);
setConnectScatterMarkers(true);
setO1LabelRotate(0);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setSeriesType(0,1);
setAxisAssignment(1,0);
setSeriesType(1,1);
setAxisAssignment(2,1);
setSeriesType(2,2);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setY2LabelDisplay(true);
setY2AxisSide(1);
setY2MajorGridDisplay(true);
setY2MajorGridStyle(0);
setY2MinorGridDisplay(false);
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setTitleString("Aluminum Melt - Monthly Tracking Report");
setFontSizeAbsolute(getTitle(),true);
setSubtitleString("Melt Loss Weights Include All Material Sent For Tolling");
setFontSizeAbsolute(getSubtitle(),true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
     TITLETEXT='Aluminum Melt - Monthly Tracking Report',
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=10,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     FONT='ARIAL',
$
TYPE=FOOTING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=8,
     COLOR='BLACK',
$
ENDSTYLE
END

This message has been edited. Last edited by: bbollmann,

Brian, try adding this to the graphstyle.

setReferenceLine (getY2Axis(), 0, 55.1);
setLineWidth (getReferenceLine (getY2Axis(), 0), 3);
setFillColor (getReferenceLine (getY2Axis(), 0), new Color (255, 0, 0));

For the % issue, If you want to display the values as a % then you have to supply the values divided by 100.

This is exactly the way that Excel works if you give a cell a format of %.

Thanks Waz, your suggestion for goal line worked nicely.

Any more suggestions on how to deal with the percentage. I modified per JG suggestion as below and the Y2 Axis displays nicely, but I can't get the graph points to display w/ 55.4% etc.

Thanks!

APP PREPENDPATH IBISAMP
-*
-* ================================================================================
-* Move the data from SQLOUT to MYSQL which can be read into variables
-* ================================================================================
-SET &TRENDLINE = 55.1
TABLE FILE CAR
PRINT
	COMPUTE D9MONTH/A12 = COUNTRY;
	COMPUTE D9PROD1/D12.0 = DEALER_COST;
	COMPUTE D9DROS1/D12.0 = RETAIL_COST;
ON TABLE HOLD AS MELTSUMM0401 FORMAT FOCUS
END
-*
-* ====================================================================================================
-* Display Graph
-* ====================================================================================================
GRAPH FILE MELTSUMM0401
SUM D9PROD1 AS 'Lbs Melted' D9DROS1 AS 'Lbs Dross' COMPUTE C9PCT/D12.2%=D9DROS1 / ( D9DROS1 + D9PROD1 ); AS 'Dross Pct'
ACROSS D9MONTH AS 'Month'
FOOTING
"Total dross lbs from central melt and holding furnaces, oily scrap, sows, turnings, and painted/assembled  "
ON GRAPH SET LOOKGRAPH VBRSTK2
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB ON
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setReferenceLine (getY2Axis(), 0, &TRENDLINE);
setLineWidth (getReferenceLine (getY2Axis(), 0), 3);
setFillColor (getReferenceLine (getY2Axis(), 0), new Color (255, 0, 0));
setY1MajorGridStepAuto(false);
setY1MajorGridStep(2);
setY2MajorGridStepAuto(false);
setY2MajorGridStep(2);
setDisplay(getDataText(0), false);
setDisplay(getDataText(1), false);
setDisplay(getDataText(2), true);
setStackedDataValueSum(false);
setTextFormatPattern(getY1Label(),"#,###.##");
setTextFormatPattern(getY2Label(),"#.##%");
setMarkerDisplay(true);
setConnectLineMarkers(true);
setConnectScatterMarkers(true);
setO1LabelRotate(0);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setSeriesType(0,1);
setAxisAssignment(1,0);
setSeriesType(1,1);
setAxisAssignment(2,1);
setSeriesType(2,2);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),1);
setY2LabelDisplay(true);
setY2AxisSide(1);
setY2MajorGridDisplay(true);
setY2MajorGridStyle(0);
setY2MinorGridDisplay(false);
setTextFormatPreset(getY2Label(),3);
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setTitleString("Aluminum Melt - Monthly Tracking Report");
setFontSizeAbsolute(getTitle(),true);
setSubtitleString("Melt Loss Weights Include All Material Sent For Tolling");
setFontSizeAbsolute(getSubtitle(),true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
     TITLETEXT='Aluminum Melt - Monthly Tracking Report',
$
     DEFMACRO=COND0001,
     MACTYPE=RULE,
     WHEN=N3 GE 0,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=10,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     FONT='TIMES NEW ROMAN',
$
TYPE=FOOTING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=8,
     COLOR='BLACK',
$
ENDSTYLE
END


  

I posted a solution to this here, seems the only way was to not use the Graph % format, but use a custom format.

Can someone tell me why my .551 Reference Line follows the same path as the Dross Pct line?

 
APP PREPENDPATH IBISAMP
-*
-* ================================================================================
-* Move the data from SQLOUT to MYSQL which can be read into variables
-* ================================================================================
-SET &TRENDLINE = 55.1
TABLE FILE CAR
PRINT
	COMPUTE D9MONTH/A12 = COUNTRY;
-*	COMPUTE D9PROD1/D12.0 = DEALER_COST;
	COMPUTE D9PROD1/D12.0 = SALES;
	COMPUTE D9DROS1/D12.0 = RETAIL_COST * 2;
	COMPUTE D9MLOS1/D10.3 = .551;
ON TABLE HOLD AS MELTSUMM0401 FORMAT FOCUS
END
-*
-* ====================================================================================================
-* Display Graph
-* ====================================================================================================
GRAPH FILE MELTSUMM0401
SUM 
	D9PROD1 AS 'Lbs Melted' 
	D9DROS1 AS 'Lbs Dross' 
	COMPUTE C9PCT/D12.2= D9DROS1 / ( D9DROS1 + D9PROD1 ); AS 'Dross Pct'
	MIN.D9MLOS1
ACROSS D9MONTH AS 'Month'
FOOTING
"Total dross lbs from central melt and holding furnaces, oily scrap, sows, turnings, and painted/assembled  "
ON GRAPH SET LOOKGRAPH VBRSTK2
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB ON
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *

-*setReferenceLine (getY2Axis(), 0, &TRENDLINE);
-*setLineWidth (getReferenceLine (getY2Axis(), 0), 3);
-*setFillColor (getReferenceLine (getY2Axis(), 0), new Color (255, 0, 0));

setY1MajorGridStepAuto(false);
setY1MajorGridStep(2);
setY2MajorGridStepAuto(false);
setY2MajorGridStep(2);
setDisplay(getDataText(0), false);
setDisplay(getDataText(1), false);
setDisplay(getDataText(2), true);
setStackedDataValueSum(false);
setTextFormatPattern(getY1Label(),"#,###.##");
setTextFormatPattern(getY2Label(),"#.##");
setMarkerDisplay(true);
setConnectLineMarkers(true);
setConnectScatterMarkers(true);
setO1LabelRotate(0);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);

setAxisAssignment(0,0);
setSeriesType(0,1);

setAxisAssignment(1,0);
setSeriesType(1,1);

setAxisAssignment(2,1);
setSeriesType(2,2);

setAxisAssignment(3,1);
setSeriesType(3,2);

setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),1);
setY2LabelDisplay(true);
setY2AxisSide(1);
setY2MajorGridDisplay(true);
setY2MajorGridStyle(0);
setY2MinorGridDisplay(false);
setTextFormatPreset(getY2Label(),3);
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setTitleString("Aluminum Melt - Monthly Tracking Report");
setFontSizeAbsolute(getTitle(),true);
setSubtitleString("Melt Loss Weights Include All Material Sent For Tolling");
setFontSizeAbsolute(getSubtitle(),true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
     TITLETEXT='Aluminum Melt - Monthly Tracking Report',
$
     DEFMACRO=COND0001,
     MACTYPE=RULE,
     WHEN=N3 GE 0,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=10,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     FONT='TIMES NEW ROMAN',
$
TYPE=FOOTING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=8,
     COLOR='BLACK',
$
ENDSTYLE
END