Hi,

I've been looking into the ibi documention , but i can't find a clear answer on how to do this , basically i want something like :



I got most of it except for how to place the Zero baseline in the middle of the graph and the Y1 and Y2 axis's going below zero

any clues?

P.

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

Though the option
setY1MustIncludeZero(true);
displays the 0 line, the major units may not necessarily read same on both sides of Y-axis. Your Y-axis major units could read like -5, 5, 15, 25 or could be the worser -3, 7, 17, 27(Even though the 0 line is displayed it is not symmetric on either side of X-axis)

The main problem is with the Autoscale options set to true, graph engine decides on what should be max and min values for the graph scale and interval (based on the data to be represented in the graph).

The way we have solved the problem is by setting off the autoscale options and manually finding and setting the max and min values along with the scale interval and setting these values.

setScaleMaxAuto(getY1Axis(),false);
setScaleMinAuto(getY1Axis(),false);
setScaleMax(getY1Axis(),&HIGHVAL);
setScaleMin(getY1Axis(),&MINVAL );

Thanks Venu,

Your code, below, is exactly what I needed.

setScaleMaxAuto(getY1Axis(),false);
setScaleMinAuto(getY1Axis(),false);
setScaleMax(getY1Axis(),&HIGHVAL);
setScaleMin(getY1Axis(),&MINVAL );

This just shows, once again, that searching FocalPoint BEFORE making a post really pays off...

Way To Go FocalPoint.

I need to write a graph similar to the one in the image above with a line overlapping on the bar graph. I am not sure how to do this in WebFocus. I thought the only way to do is to overlap two images on top of each other which may not work for us. Could someone please point me to any documentation or sample code? CAR example would be great. Thanks.

If you mean a reference line look up setReferenceLine in the graph documentation

Thanks JG for pointing me to reference line. I looked at the documentation as well several related posts. It looks like the refernce line is always a straight line whether it is a constant no. or a varible. What I would like to get is a line which depends on a field instead of a constant value that looks like the one in the image above.
Is it possible to reference a computed field in
setReferenceLine(getY1Axis(),0,10000);
Thanks.

GRAPH FILE CAR
-* Created by Advanced Graph Assistant
SUM CAR.BODY.DEALER_COST
BY CAR.ORIGIN.COUNTRY
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDepthRadius(5);
setTransparentBorderColor(getChartBackground(),true);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setPlace(true);
setReferenceLine(getY1Axis(),0,10000);
setLineWidth(getReferenceLine(getY1Axis(),0),3);
setFillColor(getReferenceLine(getY1Axis(),0),new Color(255,0,0));
ENDSTYLE
ON GRAPH SET STYLE *
TYPE=DATA, COLUMN=N2, FOCEXEC=agasum(country=N1), $
ENDSTYLE
END
-RUN
  

Create your bar graph as you have done using the AGA. Then change the series type to line for the specific series that you want. You can do that on the chart editor tab.

Thank you so much Ginny! It works great and opens up lot of possibilities for our graphing reports.