Focal Point
webfocus graph-second vertical axis [SOLVED]

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

September 19, 2012, 12:38 PM
NateH
webfocus graph-second vertical axis [SOLVED]
Hi folks,
Excel has a charting feature whereby you can select one data series to be on the right side, or 'second vertical axis.' This is especially handy when you have something with different scales, like 'revenue' and 'number of stores.' The scale for revenue can be on the left vertical axis, and the scale for stores (a much smaller number than the revenue figures) can be on the right vertical axis. I went thru webfocus advanced graph, and nothing like this seemed to pop up - has anyone wrestled with this kind of thing before? Thanks a bunch for any thoughts/direction.

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


wf 7.7
windows xp
apdf,excel
September 19, 2012, 12:58 PM
Francis Mariani
Would a "Dual-axis stacked Line" graph be what you're looking for?

Example generated by Advanced Graph Assistant:

GRAPH FILE CAR
SUM CAR.BODY.SALES CAR.SPECS.WEIGHT 
ACROSS CAR.ORIGIN.COUNTRY 
ON GRAPH SET LOOKGRAPH VLINSTK2
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(true);
setConnectLineMarkers(true);
setConnectScatterMarkers(true);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setAxisAssignment(1,1);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setY2LabelDisplay(true);
setY2AxisSide(1);
setY2MajorGridDisplay(true);
setY2MajorGridStyle(0);
setY2MinorGridDisplay(false);
setTextFormatPreset(getY2Label(),-1);
setTextFormatPattern(getY2Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
$
ENDSTYLE
END



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
September 25, 2012, 03:50 PM
NateH
THANK YOU! exactly the thing. Awesome.


wf 7.7
windows xp
apdf,excel