Hi All,

I want to generate a line graph and display only the line itself. These are called sparklines. I can generate the graph but cannot remove the bounding image frame that is displayed around it.

I tried the technique described at the IBI tech site which suggests to add the following:

-* Remove borders around the plot area (Chart Frame)
setTransparentBorderColor(getFrame(),true);
setTransparentBorderColor(getFrameSide(), true);

but it only removes the upper and right frame borders.

Any ideas? This is killing me!

Thanks,

Norb

This message has been edited. Last edited by: <Emily McAllister>,

{CODE] setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setFootnoteString("Degrees by Degree Level");
setFontSizeAbsolute(getFootnote(),true);
setFillColor(getFootnote(),new Color(0,51,102));
setTextJustHoriz(getLegendText(),1);
setFontSizeAbsolute(getLegendText(),true);
setFontSize(getLegendText(),12);
setFontStyle(getLegendText(),2);
setFillColor(getLegendText(),new Color(0,128,128));
setTextRotation(getLegendText(),0);
setTextWrap(getLegendText(),false);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFillColor(getY1Label(),new Color(128,0,0));
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setPlaceResize(getLegendText(),0);
setPlaceRotate(getLegendText(),0);
setPlaceAlign(getLegendText(),0);
setPlaceWordWrap(getLegendText(),0);
setPlace(true); [/CODE]

I pulled this out of a graph I did and it does not have any borders around the graph. I created it using graph assistant, but in advanced graph assistant it runs the same. Curious.

Hi Leah,

I cut and pasted your entire code and it ran fine. It appears that what is happening on my graph is that the x and y axis are being drawn.

I would like to not have the x and y axis displayed at all - just the line graph with the start and endpoints annotated. I'd be happy just changing the color of the axis to white but I can't figure that out either.

Thanks,

Norb

Simple Example:

-DEFAULT &CURR_DT = '19970531'
-DEFAULT ®ION  = 'Midwest'
 
-* Determine the start and end dates for the last 12 months.
-SET &CURR_YYM = EDIT(&CURR_DT, '999999');
-SET &YYM_START = AYM( &CURR_YYM, -12, 'I6YYM');
-SET &YYM_END   = AYM( &CURR_YYM,  -1, 'I6YYM');
DEFINE FILE GGSALES
  D_YY/YY = DATE;
  D_MTH/M = DATE;
  D_YYM/YYM = DATE;
END
 
GRAPH FILE GGSALES
SUM DOLLARS
BY D_YYM
WHERE D_YYM GE '&YYM_START' AND D_YYM LE '&YYM_END';
WHERE REGION EQ '®ION';
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
-* turn off 3d option.
ON GRAPH SET 3D OFF
-* remove plotting of zero values.
ON GRAPH SET VZERO OFF
-* turn off the default grid settings.
ON GRAPH SET GRID OFF
-* set absolute height to 17 px.
ON GRAPH SET VAXIS 17
-* set absolute width to 150 px.
ON GRAPH SET HAXIS 150
-* ON GRAPH HOLD AS TOUT FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setGraphType(41);                      // Vertical Absolute Line Plot
setDepthRadius(0);                     // Turn off 2 D
setDepthAngle(0);                      // Turn off 2.5D
setConnectLineMarkers(true);           // Display line connecting markers
setFillColor(getSeries(0),new Color(100 100 100));             // Change line color to Dark Grey.
setFillColor(getChartBackground(), new Color(255 255 255));    // Change chart background fill color to white.
setFootnoteDisplay(false);             // Turn off footnotes ... just in case.
setSubtitleDisplay(false);             // Turn off subtitles.
setTitleDisplay(false);                // Turn off titles.
setToolTipDisplay(false);              // Turn off tool tips
setFrameDisplay(false);                // Turn off graph frame display
setLegendDisplay(false);               // Turn off legend
setLegendAutomatic(false);             // Turn off legend automatic setting.
setO1TitleDisplay(false);              // Turn off title display for displayed series 0.
setMarkerShape(getSeries(0),0);        // Turn off marker shape for series 0.
setMarkerSize(getSeries(0),0);         // Turn off merker size for series 0.
setLineWidth(getSeries(0),1);          // Smallest line width for series 0.
setExtendToFrameEdge(true);            // Extend graph to use entire presentation area.
setO1LabelDisplay(false);              // Turn off Ordinal (Category) Axis Labels
setO1MajorGridDisplay(false);          // Turn off Ordinal (Category) Axis Major Grid lines
setO1AxisLineDisplay(false);           // Turn off Ordinal (Category) Axis display
setY1LabelDisplay(false);              // Turn off Numeric Axis Labels
setY1MajorGridDisplay(false);          // Turn off Numeric Axis Major Grid lines
setY1AxisLineDisplay(false);           // Turn off Numeric Axis display
setRect(getFrame(), new Rectangle(-16000,-16000,32000,32000)); // Set the graph display area to be the entire canvas.
setPlace(false);                       
ENDSTYLE
END  

That's a nice program D.

I run it and it works fine after changing your little typo...

Hi dhagen,

Well you nailed it! I copied your graph code and my stuff looks WONDERFUL! Woo Hoo! It appears, after testing, that the code needed for success was :

setY1AxisLineDisplay(false);
setRect(getFrame(), new Rectangle(-16000,-16000,32000,32000));

Thanks so much for your help and the well documented code. While I'm here I'm wondering if you know whether the beginning and endpoint of the series can be marked and their values displayed?

Thanks,

Norb

Norb,

You could use a similar method to this one that I suggested to Suzanne a while back. Link

If you get the first and last values within your data, you should be able to achieve your goal.

T

quote:

Originally posted by dhagen:

ON GRAPH SET GRAPHSTYLE *
setGraphType(41);                      // Vertical Absolute Line Plot
setDepthRadius(0);                     // Turn off 2 D
setDepthAngle(0);                      // Turn off 2.5D
setConnectLineMarkers(true);           // Display line connecting markers

This is one of the few pieces of code for graphs that I've seen with annotations, thank you!

I just found this: GRAPHSTYLE API documentation

This message has been edited. Last edited by: J.Hines,

Original Posting...

http://forums.informationbuild...1057331/m/6417004236


I had added some comments to help understand the rest about a year ago..

ENGINE INT CACHE SET ON

-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';

GRAPH FILE CAR
-* Created by Info Assist for Graph
SUM CAR.BODY.SALES
BY CAR.ORIGIN.COUNTRY
ON GRAPH PCHOLD FORMAT JSCHART
-* places summary values at the end of bars on bar charts, or slices on pie charts
ON GRAPH SET BARNUMB OFF
-* turn off 3d option.
ON GRAPH SET 3D OFF
-* remove plotting of zero values.
ON GRAPH SET VZERO OFF
-* turn off the default grid settings.
ON GRAPH SET GRID OFF
-* causes any text set in a string to be encrypted for transportation, and then decrypted to be displayed as written on a report
ON GRAPH SET HTMLENCODE ON
-* whether the WebFOCUS default graph styles
ON GRAPH SET GRAPHDEFAULT OFF
-* applies to PostScript and PDF reports for unit of measure for page margins, column positions, and column widths
ON GRAPH SET UNITS &WF_STYLE_UNITS
-* set absolute width to 150 px.
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
-* set absolute height to 17 px.
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
-* generates a three-dimensional graph that reflects all output data from a request containing multiple sort fields (ON, OFF, ADVANCE)
ON GRAPH SET GRMERGE ADVANCED
-* only used if GRMERGE is set to ADVANCED and specifies how many sort fields to use to create multiple graphs
ON GRAPH SET GRMULTIGRAPH 0
-* only used if GRMERGE is set to ADVANCED and specifies how many sort fields to display on the X-axis.
ON GRAPH SET GRLEGEND 0
-* GRXAXIS must be at least 1 in order to plot the graph. A value greater than one creates nested X-axes
ON GRAPH SET GRXAXIS 1
-* specifies a graph style
ON GRAPH SET LOOKGRAPH VBAR
-* parameter automatically resizes HTML5 graphs to fit their containers
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
-*setGraphType(42);                      							-*// Vertical Absolute Line Plot
setDepthRadius(30);                     						-*// Turn on/off 2D
-*setDepthRadius(0);                   							-*// Turn off 2 D
setDepthAngle(0);                      							-*// Turn on/off 2.5D
setConnectLineMarkers(true);           							-*// Display line connecting markers
setFillColor(getSeries(0),new Color(100 100 100));             	-*// Change line color to Dark Grey.
setFillColor(getChartBackground(), new Color(255 255 255));    	-*// Change chart background fill color to white.
setFootnoteDisplay(false);             							-*// Turn off footnotes ... just in case.
setSubtitleDisplay(false);             							-*// Turn off subtitles.
setTitleDisplay(false);                							-*// Turn off titles.
-*setToolTipDisplay(false);              						-*// Turn off tool tips
setFrameDisplay(false);                							-*// Turn off graph frame display
setLegendDisplay(false);               							-*// Turn off legend
setLegendAutomatic(false);             							-*// Turn off legend automatic setting.
setO1TitleDisplay(false);              							-*// Turn off title display for displayed series 0.
setMarkerShape(getSeries(0),0);        							-*// Turn off marker shape for series 0.
setMarkerSize(getSeries(0),0);         							-*// Turn off merker size for series 0.
setLineWidth(getSeries(0),1);          							-*// Smallest line width for series 0.
setExtendToFrameEdge(true);            							-*// Extend graph to use entire presentation area.
setO1LabelDisplay(false);              							-*// Turn off Ordinal (Category) Axis Labels
setO1MajorGridDisplay(false);          							-*// Turn off Ordinal (Category) Axis Major Grid lines
setO1AxisLineDisplay(false);           							-*// Turn off Ordinal (Category) Axis display
setY1LabelDisplay(false);              							-*// Turn off Numeric Axis Labels
setY1MajorGridDisplay(false);          							-*// Turn off Numeric Axis Major Grid lines
setY1AxisLineDisplay(false);           							-*// Turn off Numeric Axis display
-*setRect(getFrame(), new Rectangle(-16000,-16000,3200,3200));	-*// Set the graph display area to be the entire canvas.
setPlace(false);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT='WebFOCUS Report', $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
*END
ENDSTYLE
END