Focal Point
[SOLVED]Chart Legends Change Bar Chart Width

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

January 04, 2016, 02:51 PM
GavinL
[SOLVED]Chart Legends Change Bar Chart Width
Ok, we have ran into this many times, but luckily, we ended up going in a different direction. I'm attempting to create a standard vertical bar chart, but when I add Legends to it, each of the vertical bars, shrink in width, making it look anorexic. How do I make them stay the way they were, before I added legends?



ENGINE INT CACHE SET ON


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

-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE ibisamp/car
-* Created by Info Assist for Graph
SUM CAR.BODY.SALES
BY CAR.COMP.CAR
ACROSS CAR.COMP.CAR
WHERE CAR.BODY.SALES GT 0;
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET ARGRAPHENGIN JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT

setPieDepth(0);
setPieTilt(0);
setDepthRadius(0); 
setCurveFitEquationDisplay(false); 
setPlace(true); 

*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDisplay(getLegendArea(),true);
setDisplay(getO1Label(),false);
setDisplay(getO1Title(),false);
setDisplay(getY1Title(),false);
setColorMode(1);

*END
ENDSTYLE
END

-RUN

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



- FOCUS Man, just FOCUS!
-----------------------------
Product: WebFOCUS
Version: 8.1.04
Server: Windows 2008 Server
January 05, 2016, 02:34 PM
GavinL
I guess no answer means, it is what it is and I need to open a issues ticket. Roll Eyes



- FOCUS Man, just FOCUS!
-----------------------------
Product: WebFOCUS
Version: 8.1.04
Server: Windows 2008 Server
January 05, 2016, 02:52 PM
Francis Mariani
When I add
setDisplay(getLegendArea(),false);
I still get anorexic bars.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
January 06, 2016, 06:00 AM
Jay Potter
Will a horizontal bar work for you?

ENGINE INT CACHE SET ON


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

-DEFAULTH &WF_TITLE='WebFOCUS Report';
-*IA_GRAPH_BEGIN

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.COMP.CAR
WHERE CAR.BODY.SALES GT 0;
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET ARGRAPHENGIN JSCHART
ON GRAPH SET GRWIDTH 1
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH HBAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);
*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
-*IA_GRAPH_FINISH
-RUN


WebFocus 8.1.5
iSeries/Windows
DB2/SQL/Access
Dev Studio
App Studio
Maintain
ReportCaster
January 06, 2016, 09:20 AM
GavinL
quote:
When I add
setDisplay(getLegendArea(),false);
I still get anorexic bars.

Francis


It's the ACROSS that does it. This is added automatically, when you add CAR to the LEGEND within Info Assist.



- FOCUS Man, just FOCUS!
-----------------------------
Product: WebFOCUS
Version: 8.1.04
Server: Windows 2008 Server
January 06, 2016, 09:21 AM
GavinL
quote:
Will a horizontal bar work for you?


Unfortunately, this requirement is vertical bar chart.



- FOCUS Man, just FOCUS!
-----------------------------
Product: WebFOCUS
Version: 8.1.04
Server: Windows 2008 Server
January 06, 2016, 09:49 AM
<nick z>
Change the LOOKGRAPH to VBRSTK1.
January 06, 2016, 10:03 AM
GavinL
quote:
Change the LOOKGRAPH to VBRSTK1.


DING! DING! DING!

WOW, that should be an option through the UI.

Thanks



- FOCUS Man, just FOCUS!
-----------------------------
Product: WebFOCUS
Version: 8.1.04
Server: Windows 2008 Server
January 06, 2016, 10:35 AM
GavinL
Well, that worked but once I add in my Data Text, it errors the report saying:

ERROR
----------
TypeError: Unable to get property 'value' of undefined or null reference


All I added was:
setDisplay(getDataText(0), true);
setFillColor(getSeries(0),new Color(155,218,255));
setDisplay(getDataText(1), true);
setFillColor(getSeries(1),new Color(169,169,169));
setDisplay(getDataText(2), true);
setFillColor(getSeries(2),new Color(82,207,167));


If I comment out the following it works, but only has Data Text on the first of 3 vertical bars.

setDisplay(getDataText(1), true);
setDisplay(getDataText(2), true);




- FOCUS Man, just FOCUS!
-----------------------------
Product: WebFOCUS
Version: 8.1.04
Server: Windows 2008 Server
January 06, 2016, 11:27 AM
<nick z>
Here is a code workaround:
Add
  
*GRAPH_JS
dataLabels:{visible: true, formatCallback: 
function(v)
{
    return v.value;
}
},
    series: [
    {series: 'reset', showDataValues: true}
    ],
*END


Thanks.
Nick.
January 06, 2016, 12:36 PM
GavinL
I'm being school'd...

WF = Workaround Fix

Thanks,



- FOCUS Man, just FOCUS!
-----------------------------
Product: WebFOCUS
Version: 8.1.04
Server: Windows 2008 Server