Focal Point
[SOLVED] Scatter Graph

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2127081276

August 14, 2014, 11:49 AM
MMcDonald
[SOLVED] Scatter Graph
I am trying to create scatter graph where you have a product category as the sort field and value range across. Tha catch is to have all the values on one linear line across the graph with data points (markers) for each value.

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


8.0.9, Windows
excel / pdf
August 21, 2014, 08:16 AM
MMcDonald
SOLVED:

GRAPH FILE CAR
SUM CAR.SPECS.WEIGHT AS 'WEIGHT'
BY CAR.SPECS.WEIGHT
ACROSS CAR.ORIGIN.COUNTRY
ON GRAPH PCHOLD AS HOLD FORMAT PNG
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET HAXIS 400
ON GRAPH SET VAXIS 500
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH HLINE
ON GRAPH SET GRAPHSTYLE *
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);
setScaleMinAuto(getY1Axis(),false);
setScaleMin(getY1Axis(),-5000.0);
setScaleMaxAuto(getY1Axis(),false);
setScaleMax(getY1Axis(),5000.0);
setGridStepAuto(getY1MajorGrid(),false);
setGridStep(getY1MajorGrid(),1.0);
setUseSeriesShapes(true);
setMarkerSizeDefault(50);
setScaleMustIncludeZero(getX1Axis(),false);
setScaleMustIncludeZero(getY1Axis(),false);
setScaleMustIncludeZero(getY2Axis(),false);
setMarkerSizeDefault(60);
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDisplay(getLegendArea(),false);
setMarkerShape(getAllSeries(),3);
setReferenceTextPosition(getReferenceLineTextY1(0),0);
setDisplay(getReferenceLineY1(0),true);
setBorderColor(getReferenceLineY1(0),new Color(255,0,0));
setFillColor(getReferenceLineTextY1(0),new Color(255,0,0));
setReferenceLineValueY1(0,1000.0);
setLineWidth(getReferenceLineY1(0),2);
setLineBasicStrokeType(getReferenceLineY1(0),12);
setTextString(getReferenceLineTextY1(0),"Normal-Low");
setDisplay(getReferenceLineTextY1(0),true);
setFillColor(getReferenceLineTextY1(0),new Color(0,0,0));
setFontName(getReferenceLineTextY1(0),"Verdana");
setFontSizeAbsolute(getReferenceLineTextY1(0),true);
setFontSizeInPoints(getReferenceLineTextY1(0),7);
setReferenceTextPosition(getReferenceLineTextY1(0),0);
setDisplay(getAnnotation(0),true);
setTextString(getAnnotation(0),"Normal-Low");
setFillColor(getAnnotation(0),new Color(0,128,0));
setRect(getAnnotation(0),new Rectangle(0,0,-11500,14500));
setFontSizeAbsolute(getAnnotation(0),true);
setFontSizeInPoints(getAnnotation(0),8.0);
setFillColor(getSeries(0),new Color(255,0,128));
setFillColor(getSeries(1),new Color(255,0,128));
setFillColor(getSeries(2),new Color(255,0,128));
setFillColor(getSeries(3),new Color(255,0,128));
setFillColor(getSeries(4),new Color(255,0,128));
setFillColor(getSeries(5),new Color(255,0,128));
setFillColor(getSeries(6),new Color(255,0,128));
setFillColor(getSeries(7),new Color(255,0,128));
setFillColor(getSeries(8),new Color(255,0,128));
setFillColor(getSeries(9),new Color(255,0,128));
setFillColor(getSeries(10),new Color(255,0,128));
setFillColor(getSeries(11),new Color(255,0,128));
setFillColor(getSeries(12),new Color(255,0,128));
setFillColor(getSeries(13),new Color(255,0,128));
setFillColor(getSeries(14),new Color(255,0,128));
setFillColor(getSeries(15),new Color(255,0,128));
setFillColor(getSeries(16),new Color(255,0,128));
setFillColor(getSeries(17),new Color(255,0,128));
setFillColor(getSeries(18),new Color(255,0,128));
setFillColor(getSeries(19),new Color(255,0,128));
setFillColor(getSeries(20),new Color(255,0,128));
setTransparentFillColor(getSeries(0),true);
setTransparentFillColor(getSeries(1),true);
setTransparentFillColor(getSeries(2),true);
setTransparentFillColor(getSeries(3),true);
setTransparentFillColor(getSeries(4),true);
setTransparentFillColor(getSeries(5),true);
setTransparentFillColor(getSeries(6),true);
setTransparentFillColor(getSeries(7),true);
setTransparentFillColor(getSeries(8),true);
setTransparentFillColor(getSeries(9),true);
setTransparentFillColor(getSeries(10),true);
setTransparentFillColor(getSeries(11),true);
setTransparentFillColor(getSeries(12),true);
setTransparentFillColor(getSeries(13),true);
setTransparentFillColor(getSeries(14),true);
setTransparentFillColor(getSeries(15),true);
setTransparentFillColor(getSeries(16),true);
setTransparentFillColor(getSeries(17),true);
setTransparentFillColor(getSeries(18),true);
setTransparentFillColor(getSeries(19),true);
setTransparentFillColor(getSeries(20),true);
setBorderColor(getSeries(0),new Color(0,0,255));
setBorderColor(getSeries(1),new Color(0,0,255));
setBorderColor(getSeries(2),new Color(0,0,255));
setBorderColor(getSeries(3),new Color(0,0,255));
setBorderColor(getSeries(4),new Color(0,0,255));
setBorderColor(getSeries(5),new Color(0,0,255));
setBorderColor(getSeries(6),new Color(0,0,255));
setBorderColor(getSeries(7),new Color(0,0,255));
setBorderColor(getSeries(8),new Color(0,0,255));
setBorderColor(getSeries(9),new Color(0,0,255));
setBorderColor(getSeries(10),new Color(0,0,255));
setBorderColor(getSeries(11),new Color(0,0,255));
setBorderColor(getSeries(12),new Color(0,0,255));
setBorderColor(getSeries(13),new Color(0,0,255));
setBorderColor(getSeries(14),new Color(0,0,255));
setBorderColor(getSeries(15),new Color(0,0,255));
setBorderColor(getSeries(16),new Color(0,0,255));
setBorderColor(getSeries(17),new Color(0,0,255));
setBorderColor(getSeries(18),new Color(0,0,255));
setBorderColor(getSeries(19),new Color(0,0,255));
setBorderColor(getSeries(20),new Color(0,0,255));
setMarkerSize(getSeries(0),50);
setMarkerSize(getSeries(1),50);
setMarkerSize(getSeries(2),50);
setMarkerSize(getSeries(3),50);
setMarkerSize(getSeries(4),50);
setMarkerSize(getSeries(5),50);
setMarkerSize(getSeries(6),50);
setMarkerSize(getSeries(7),50);
setMarkerSize(getSeries(8),50);
setMarkerSize(getSeries(9),50);
setMarkerSize(getSeries(10),50);
setMarkerSize(getSeries(11),50);
setMarkerSize(getSeries(12),50);
setMarkerSize(getSeries(13),50);
setMarkerSize(getSeries(14),50);
setMarkerSize(getSeries(15),50);
setMarkerSize(getSeries(16),50);
setMarkerSize(getSeries(17),50);
setMarkerSize(getSeries(18),50);
setMarkerSize(getSeries(19),50);
setMarkerSize(getSeries(20),50);
setMarkerShape(getSeries(0),3);
setMarkerShape(getSeries(1),3);
setMarkerShape(getSeries(2),3);
setMarkerShape(getSeries(3),3);
setMarkerShape(getSeries(4),3);
setMarkerShape(getSeries(5),3);
setMarkerShape(getSeries(6),3);
setMarkerShape(getSeries(7),3);
setMarkerShape(getSeries(8),3);
setMarkerShape(getSeries(9),3);
setMarkerShape(getSeries(10),3);
setMarkerShape(getSeries(11),3);
setMarkerShape(getSeries(12),3);
setMarkerShape(getSeries(13),3);
setMarkerShape(getSeries(14),3);
setMarkerShape(getSeries(15),3);
setMarkerShape(getSeries(16),3);
setMarkerShape(getSeries(17),3);
setMarkerShape(getSeries(18),3);
setMarkerShape(getSeries(19),3);
setMarkerShape(getSeries(20),3);
setTextString(getY1Title(),"TEST");
setDisplay(getY1Title(),true);
setPlaceResize(getY1Title(),0);
setFontSizeAbsolute(getY1Title(), true);
setFontSizeInPoints(getY1Title(), 9);
setFillMissingData(1);
setZeroValueDataTextDisplay(false);
ENDSTYLE
END


8.0.9, Windows
excel / pdf