I have created a bar chart which will show two bars for 201611 and 201612 on the x axis and revenue on the y-axis.Revenue for 201611 is $26,748,368.64 and for 201612 $ 27,710,991.14. These two bar charts are blue in color.
1)Is it possible to keep the 201612 in blue color, but the part of the bar where it exceeds the 201611 i.e.growth($ 27,710,991.14-$26,748,368.64=962622.5) in green color?
2)A horizontal line from y-axis label to 201612 bar to show the point from where the growth started.
I have pasted my code below, Please provide your inputs if you have a way to do this.
ENGINE INT CACHE SET ON SET PAGE-NUM=NOLEAD -DEFAULTH &WF_HTMLENCODE=OFF; SET HTMLENCODE=&WF_HTMLENCODE SET ARGRAPHENGINE=JSCHART -DEFAULTH &WF_EMPTYREPORT=ON; SET EMPTYREPORT=&WF_EMPTYREPORT SET EMBEDHEADING=ON SET GRAPHDEFAULT=OFF -DEFAULTH &WF_STYLE_UNITS='PIXELS'; -DEFAULTH &WF_STYLE_HEIGHT='405.0'; -DEFAULTH &WF_STYLE_WIDTH='770.0'; -DEFAULTH &WF_TITLE='WebFOCUS Report'; GRAPH FILE wf_retail_lite SUM WF_RETAIL_LITE.WF_RETAIL_SALES.REVENUE_US BY WF_RETAIL_LITE.WF_RETAIL_TIME_SALES.TIME_YEARMTH WHERE WF_RETAIL_LITE.WF_RETAIL_TIME_SALES.TIME_YEARMTH GE 201611; WHERE WF_RETAIL_LITE.WF_RETAIL_TIME_SALES.TIME_YEARMTH LE 201612; ON GRAPH PCHOLD FORMAT 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 LOOKGRAPH BAR 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/ibi_themes/Warm.sty,$ TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $ TYPE=DATA, COLUMN=N1, BUCKET=x-axis, $ TYPE=DATA, COLUMN=N2, BUCKET=y-axis, $ *GRAPH_SCRIPT setReportParsingErrors(false); setSelectionEnableMove(false); *END ENDSTYLE END -RUN
BI DevThis message has been edited. Last edited by: FP Mod Chuck,
There is no way out of the box to do number 1 you can't split the color of a bar based on comparing values between them. For number 2 I was thinking a reference line but when I tried that with your example the reference line went across the highest value for the revenue field and otherwise you would need to hard code a value which isn't what you want. So I am sorry to have to tell you that I don't think it is possible but I have been wrong before. Maybe someone else has a way. Maybe a D3 option but I am not real savvy with those.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
Yes, I could not do that out of the box so far, checking to see if somebody else has done something similar. Thanks.
|Powered by Social Strata|