I am new to using GRAPH FILE. The bar graph that is produced for each Year/Month instance in the graph from the code below does not provide any spacing between each vertical bar. Is there any way to add/control spacing between each vertical bar in the graph?

SET LOOKGRAPH=BAR 
SET GRAPHEDIT=SERVER 
SET GRID=ON
SET BARNUM=ON
SET 3D=ON
-*SET VERO=ON
-RUN
-*
-SET &PRCT=IF &INSTR_TYPE EQ 'M' THEN 'D3%' ELSE 'D6.2%'; 
-*
JOIN INSTRUMENT_KEY IN CMB800F1 TO ALL INSTRUMENT_KEY IN FIN_INSTR_ORIGIN_T AS J1
DEFINE FILE CMB800F1
INSTR_COUNT/D15=IF (&FILTER_DATE.EVAL NE MISSING) AND (&FILTER_DATE.EVAL NE 0)  THEN 1 ELSE 0;
&FILTER_DATE.EVAL_&DTEFRMT.EVAL/&DTEFRMT.EVAL=&FILTER_DATE.EVAL;
END
-RUN
TABLE FILE CMB800F1
SUM MIN.&FILTER_DATE.EVAL_&DTEFRMT.EVAL AS MIN_&FILTER_DATE.EVAL_&DTEFRMT.EVAL
    MAX.&FILTER_DATE.EVAL_&DTEFRMT.EVAL AS MAX_&FILTER_DATE.EVAL_&DTEFRMT.EVAL
-*
SUM INSTR_COUNT 
-*
 BY &FILTER_DATE.EVAL_&DTEFRMT.EVAL
-*
WHERE &FILTER_DATE.EVAL GE &TRANS_DATE_GE.EVAL
WHERE &FILTER_DATE.EVAL LE &TRANS_DATE_LE.EVAL
WHERE INSTR_TYPE_CODE EQ '&INSTR_TYPE.EVAL'
-*
ON TABLE SET ASNAMES ON 
ON TABLE HOLD AS INSTR_TYPE_COUNTS
END
-RUN
-*
-IF &LINES EQ 0 THEN GOTO NO_RECORDS ELSE GOTO DO_OUTPUT;
-*
-DO_OUTPUT
-*
&RPTYPE.EVAL FILE INSTR_TYPE_COUNTS
HEADING CENTER
-*
"&RPT_HEADING.EVAL"
"<MIN_&FILTER_DATE.EVAL_&DTEFRMT.EVAL to <MAX_&FILTER_DATE.EVAL_&DTEFRMT.EVAL</1"
 
SUM MIN_&FILTER_DATE.EVAL_&DTEFRMT.EVAL NOPRINT
    MAX_&FILTER_DATE.EVAL_&DTEFRMT.EVAL NOPRINT
-*
SUM INSTR_COUNT AS 'Record Count'
-*
-IF  &RPTYPE EQ 'TABLE' THEN GOTO BY_YEAR     ELSE
- IF &RPTYPE EQ 'GRAPH' THEN GOTO ACROSS_YEAR ELSE GOTO SORT_DONE;
-*
-BY_YEAR
BY &FILTER_DATE.EVAL_&DTEFRMT.EVAL AS ''
-GOTO SORT_DONE
-*
-ACROSS_YEAR
ACROSS &FILTER_DATE.EVAL_&DTEFRMT.EVAL AS ''
-GOTO SORT_DONE
-*
-SORT_DONE
-* 
END
-RUN
-NO_RECORDS

This message has been edited. Last edited by: FP Mod Chuck,

Are you using WebFOCUS 7.7?

What happens if you just create a chart off of a sample table? Does it do the same thing? I don't see any styling in your chart so you're probably using all default values for how the chart should be rendered.

Yes, I am using WebFOCUS 7.7 and I am allowing to use default styling. I could not find any technical documentation about how to control the spacing. Can you provide a reference in the tech docs? Much appreciated.

The graphics in 7.x release aren't as robust as the 8.x and I haven't used 7.x for a long time, so I can't remember how to control the spacing of the Bars. Maybe you can sift through the doc here http://documentation.informati...s/wf77graphtools.pdf to see if there's something you can use.

Thanks, will check it out.

act4bsa,
The riser width is a percentage of the space available for each group of bars.

Play with these settings, see if any work for you:

-SORT_DONE
ON GRAPH SET GRAPHSTYLE *
-*Adjust Riser Column Width
setRiserWidth(90);
setLineWidth(getSeries(0),6)
setLineWidth(getSeries(1),6)
setLineWidth(getSeries(2),6)

Link to WebFOCUS 7.7.* documentation in PDF format: Technical Content Library - WebFOCUS 7.7.x

Look for "WebFOCUS Graphics 7.7.03". The Java-based chart syntax is not that easy to decipher for beginners. It might be a good idea to use the GUI Advanced Graph Assistant in Developer Studio to mock up a chart. The Advanced Graph Assistant generates the Java-based chart syntax.

This styling helped a little but not as much as I had hoped but turning the numbers off on the graph really cleaned it up nicely. Thanks.

 
ON GRAPH SET GRAPHSTYLE *
   setRiserBarGroupSpacing(100);
ENDSTYLE

ON GRAPH SET LOOKGRAPH BAR  
ON GRAPH SET BARNUMB OFF 

Thanks Tom, I tried the settings and it did not make a noticeable change.

Francis, unfortunately I do not have Developer Studio.

Maybe I need to increase the size of the overall chart/graph. Is there a setting for that?

ON GRAPH SET HAXIS 1000
ON GRAPH SET VAXIS 600

HAXIS: Graph width in pixels, sort of.
VAXIS: Graph height in pixels, sort of.

From Creating Reports With WebFOCUS Language:

The width (or horizontal axis) of each graph, which includes any surrounding text, is automatically set to 770 pixels. When setting the graph width, you should allow for the inclusion of any text required for the vertical axis and its labels along the left margin.

To maximize display space, you can limit the size of your labels through the use of either AS phrases or DECODE expressions.

The height (or vertical axis) of your graph is automatically set to 405 pixels.

The vertical axis is automatically set (VAUTO=ON) to cover the total range of plotted values. The height of the axis is set as high as possible (taking into consideration the presence of any headings or footings and the need to provide suitably rounded vertical class markers). The range is divided into intervals called "classes." The scale is normalized to provide class values rounded to the appropriate multiples and powers of 10 for the intervals plotted on the axis.

That seems to be what I needed for my Thicker Bars in a Graph post.

setRiserBarGroupSpacing(100)

or

setRiserWidth(90);
setLineWidth(getSeries(0),6)
setLineWidth(getSeries(1),6)
setLineWidth(getSeries(2),6)

I'll check that out when these brush fires stop.

Act4bsa,

quote:

I do not have Developer Studio.

Can you edit it text via the ibi_apps page?

Francis ,

Quote: "Give me code, or give me retirement." ... I need the code till retirement... As, I'm sure many others are think...