[SOLVED] Adjustment of Graph Scale

Hi All,

I have a report which has a stacked bar chart. Two of the parameters(warehouse number and Org number) are passed to the chart from the Listbox in the dashboard. My graph should display the qty shipped on the week from the warehouse and Org selected. When My parameter is ALL/_FOC_NULL, The report is displaying in a nice way.

But when there is a specific value is passed, the graph y axis minimum scale starts with the sum.(sum of qty). So the graph is showing nothing as the min value of the scale is the highest total.

I want the graph to always start from the zero, whatever is passed as the parameter. This is an existing report done by another person. I am not able to open in any of the Graph Editor, cause so many other definitions, DM and &var are tied around the graph.

So I am editing thru Text editor. If any one can give me an idea which property or settings do I need to change.

We are using Web focus 7.7.03 on
windows 7.

Thanks

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

Posts: 36 | Registered: April 11, 2012

Prarie

Virtuoso

posted

Hide Post

I believe it is this

setScaleFromZero(true);

Posts: 1903 | Location: San Antonio | Registered: February 28, 2005

Ignored post by Prarie posted

Show Post

Mary

Silver Member

posted

Hide Post

Hi Prarie,

Thanks for the reply. But this setScaleFromZero is not working for me. I think it is because it has dynamic calculation for the legends and some other calculations for the looping as it is a stacked bar chart.

Here is a piece of code from program. If you or any others have a new idea , please share it here in the Forum.

GRAPH FILE OUTBOUND
HEADING
"&D_MEASURES - Total &TMOD <+0> -* Created by Advanced Graph Assistant
SUM

-REPEAT :Show_Modes FOR &N FROM 1 TO &MODES_NUM ;
MODE&N AS '&MODE&N.EVAL'
-:Show_Modes
BY SHIPDATE NOPRINT
BY OUTBOUND.OUTBOUND.DIS_DATE AS 'Ship Date'
WHERE OT_TYPE EQ 'SCHED'
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HAXIS 560
ON GRAPH SET VAXIS 278
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 2
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBIRIADarkOceanRounded.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
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);
setTransparentBorderColor(getChartBackground(),true);
setPlace(true);
setDepthRadius(0);
setDepthAngle(0);
setDisplay(getY1MajorGrid(),false);
setDisplay(getO1MajorGrid(),false);
setTransparentFillColor(getFrame(),true);
setTransparentBorderColor(getFrame(),true);
setTextRotation(getO1Label(),3);
setFontName(getY1Label(),"Arial");
setFontSizeAbsolute(getY1Label(),true);
setFontSizeInPoints(getY1Label(),8);
setPlaceResize(getY1Label(),0);
setFontName(getO1Label(),"Arial");
setFontSizeAbsolute(getO1Label(),true);
setFontSizeInPoints(getO1Label(),8);
setPlaceResize(getO1Label(),0);
setRiserWidth(50);
setRiserBarGroupSpacing(20);
setFillColor(getLegendArea(),new Color(0,0,0));
setFontName(getLegendText(),"Arial");
setFontSizeAbsolute(getLegendText(),true);
setFontSizeInPoints(getLegendText(),8);
setPlaceResize(getLegendText(),0);
setFillColor(getLegendText(),new Color(255,255,255));
setFillColor(getSeries(2),new Color(0,255,0));
setFillColor(getSeries(3),new Color(0,0,255));
setFillColor(getSeries(0),new Color(255,128,0));
setFillColor(getSeries(1),new Color(255,0,0));
setFillColor(getSeries(4),new Color(128,128,128));
setFillColor(getSeries(5),new Color(255,255,0));
setFillColor(getSeries(6),new Color(128,0,128));
setFillColor(getSeries(7),new Color(255,128,255));
ENDSTYLE
ON GRAPH SET STYLE *

Thanks ,
Mary...

Posts: 36 | Registered: April 11, 2012

Ignored post by Mary posted

Show Post

Mary

Silver Member

posted

Hide Post

Hi

I found the answer from the manual Webfocus Graphics. I added the following line to my chart property, it solved my problem.

setY1MustIncludeZero(true);

Thanks

Posts: 36 | Registered: April 11, 2012

Ignored post by Mary posted

Show Post

spunkkaran

Member

posted

Hide Post