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>,

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.

Changing the 100% in graph to real percentage.
http://forums.informationbuild...891090941#8891090941

[SOLVED] Display Percentage (%) symbol next to Y-Axis values
http://forums.informationbuild...517082926#1517082926

graph percentage
http://forums.informationbuild...711068331#9711068331

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.

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