I need to create a horizontal bar chart sorted by highest volume. I need the labels on the bars to be percent change from year ago without volume showing up. I foolishly thought this would be easy but it seems I may have been mistaken. This chart will end up in a power point deck.This message has been edited. Last edited by: <Kathryn Henning>,
WebFOCUS 7.6 Windows, All Outputs
July 22, 2015, 08:22 AM
Tamra
Hi J.L Hinds,
This is a friendly follow up to your graph question.
While we wait for others to reply may I suggest searching on the forum for words such as 'graph percentage'.
There are many examples that possibly you can pull from. Here are a few I have found.
You may need to create a HOLD file with the values you need and graph off the HOLD file.
Good luck and keep us posted if you have further questions or if you have figure out a resolution.
Thank you for participating in the Focal Point Forum.
Kindest regards, Tamra Colangelo Focal Point Moderator Information Builders Inc.
WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
July 22, 2015, 10:18 AM
Spence
Hello J.L.Hinds,
See if this helps. Created with app studio version 8008
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 CAR -* Created by Info Assist for Graph SUM CAR.SPECS.FUEL_CAP AS 'Fuel Capacity' COMPUTE NEW_SEATS/I9=IF CAR EQ 'DATSUN' OR 'AUDI' THEN ( SEATS * ( 1 - 2 ) ) ELSE SEATS ; AS '' BY TOTAL HIGHEST CAR.SPECS.FUEL_CAP NOPRINT BY CAR.COMP.CAR ON GRAPH PCHOLD FORMAT JSCHART ON GRAPH SET VZERO OFF ON GRAPH SET HTMLENCODE ON ON GRAPH SET GRAPHDEFAULT OFF 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 2 ON GRAPH SET LOOKGRAPH HBRSTK1 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, $ TYPE=DATA, COLUMN=N2, COLOR=RED, WHEN=NEW_SEATS LT 0, $ TYPE=DATA, COLUMN=N2, COLOR=BLUE, WHEN=NEW_SEATS GE 0, $ *GRAPH_SCRIPT setReportParsingErrors(false); setSelectionEnableMove(false); setSeriesType(0,1); setTransparentFillColor(getSeries(1), true); setDisplay(getDataText(0), false); setFillColor(getFrame(),new Color(255,255,255)); setFillColor(getSeries(1),new Color(255,255,255)); setPieTilt(0); setPieDepth(0); setDepthRadius(0); setDepthAngle(0); setColorMode(1); setFillColor(getSeries(0),new Color(48,94,213)); setDisplay(getDataText(),false); setDataTextPosition(0); setDisplay(getDataText(1), true); setFillColor(getDataText(),new Color(255,0,0)); setStackedDataValueSum(false); setDisplay(getDataTextStackedTotalOnTop(),false); *END ENDSTYLE END
WF 8 version 8.2.04. Windows. In focus since 1990.