December 08, 2010, 11:40 AM
Tomsweb [SOLVED] display cumulative totals unstacked bar graph
Hello graph aficionados!
I have a non-stacked bar graph on which I
want to display ONLY the total of the bars.
Here is a great working sample with the CAR file.
quote:
GRAPH FILE CAR SUM CAR.BODY.DEALER_COST CAR.BODY.SALES CAR.BODY.RETAIL_COST ACROSS CAR.ORIGIN.COUNTRY ON GRAPH SET LOOKGRAPH VBAR ON GRAPH SET GRAPHSTYLE * setDisplay(getDataText(), true ); setFillColor(getDataText(),new Color(0,0,255)); setPlace(true); ENDSTYLE END -RUN
I have applied it to a graph we have working
with the users, and I can't get the totals to
display as I hoped.
I have posted my trouble code below:
quote:
GRAPH FILE CVM_07J SUM AVEMONS_07 AS ' ' BY COVGRP ACROSS YEAR AS ' ' HEADING "Average Number ... " "Ordered by ... " "FY 2007" FOOTING "As of &FRPT_MNM &CURYR" 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 1 ON GRAPH SET GRXAXIS 1 ON GRAPH SET GRAPHSTYLE * setReportParsingErrors(false); setSelectionEnableMove(false); setDepthRadius(5); setDisplay(getDataText(), true ); setFillColor(getDataText(),new Color(0,0,255)); setPlace(true); setCurveFitEquationDisplay(false); setDisplay(getDataText(0), false); setDisplay(getDataText(1), false); setDisplay(getDataText(2), false); setDisplay(getDataText(3), false); setDisplay(getDataText(4), false); setDisplay(getDataText(5), false); setDisplay(getDataText(6), false); setDisplay(getDataText(7), false); setDisplay(getDataText(8), false); setDisplay(getDataText(9), false); setDisplay(getDataText(10), false); setDisplay(getDataText(11), false); setDisplay(getDataText(12), false); setDisplay(getDataText(13), false); setDisplay(getDataText(14), false); setDisplay(getDataText(15), false); setDisplay(getDataText(16), false); setDisplay(getDataText(17), false); setDisplay(getDataText(18), false); setDisplay(getDataText(19), false); setDisplay(getDataText(20), false); setDisplay(getDataText(21), false); setDisplay(getDataText(22), false); setDisplay(getDataText(23), false); setDisplay(getDataText(24), false); setDisplay(getDataText(25), false); setDisplay(getDataText(26), false); setDisplay(getDataText(27), false); setDisplay(getDataText(28), false); setDisplay(getDataText(29), false); setDisplay(getDataText(30), false); setDisplay(getDataText(31), false); setDisplay(getDataText(32), false); setDisplay(getDataText(33), false); setDisplay(getDataText(34), false); setDisplay(getDataText(35), false); setDisplay(getDataText(36), false); setDisplay(getDataText(37), false); setDisplay(getDataText(38), false); setDisplay(getDataText(39), false); setDisplay(getDataText(40), false); setDisplay(getDataText(41), false); setDisplay(getDataText(42), false); setDisplay(getDataText(43), false); setDisplay(getDataText(44), false); setDisplay(getDataText(45), false); setDisplay(getDataText(46), false); setDisplay(getDataText(47), false); setDisplay(getDataText(48), false); setDisplay(getDataText(49), false); setDisplay(getDataText(50), false); setDisplay(getDataText(51), false); setDisplay(getDataText(52), false); setDisplay(getDataText(53), false); setDisplay(getDataText(54), false); setDisplay(getDataText(55), false); setDisplay(getDataText(56), false); setDisplay(getDataText(57), false); setDisplay(getDataText(58), false); setDisplay(getDataText(59), false); setDisplay(getDataText(60), false); setDisplay(getDataText(61), false); setDisplay(getDataText(62), false); setDisplay(getDataText(63), false); ENDSTYLE -* ON GRAPH SET STYLE * TYPE=HEADING, OBJECT=TEXT, ITEM=1, SIZE=9, COLOR='BLACK', STYLE=NORMAL, $ TYPE=FOOTING, SIZE=9, COLOR='BLACK', BACKCOLOR='WHITE', STYLE=NORMAL, $ ENDSTYLE END -RUN
I am new to the graphing side of things I'd
appreciate any insights.
Thanks!
This message has been edited. Last edited by: Kerry , December 14, 2010 12:00 PM December 08, 2010, 12:22 PM
Tom Flynn setDisplay(getDataTextStackedTotalOnTop(), true);
December 08, 2010, 12:49 PM
Tomsweb quote:
setDisplay(getDataTextStackedTotalOnTop(), true);
Sorry Tom,
My experience has been that
quote:
setDisplay(getDataTextStackedTotalOnTop(), true);
only works for stacked graphs.
December 08, 2010, 01:14 PM
Tomsweb Tony,
I have changed my code to this:
quote:
setReportParsingErrors(false); setSelectionEnableMove(false); setDepthRadius(5); setPlace(true); setCurveFitEquationDisplay(false); -**** setDisplay(getDataText(), true ); setFillColor(getDataText(),new Color(0,0,255)); -*** ENDSTYLE
And I am pleased to say that it works, and it
preserves the rollovers (for the more discovery
-oriented users)!
Now, lets see if this idea works with across multiple years (hence the ACROSS). Crossing my
fingers....
December 08, 2010, 01:58 PM
Tomsweb Yes Tony, my code change does work with
ACROSS for multiple years. Now I've been
playing with the
quote:
setDataTextPosition();
command.
Would you happen to know if I can edit
the FONT size of the text which displays
the totals ?
thanks!
December 08, 2010, 03:17 PM
Tom Flynn Who's Tony?
Search on: setFontSizeInPoints
December 08, 2010, 03:27 PM
Tomsweb Ooops, my human side showed, apologize for the error.
Thanks for the
quote:
setFontSizeInPoints
help.