Below is portion of code for InfoAssist Bar Graph displaying BUSINESS_UNIT ON X Axis and SUM.VTotalHrs on Y Axis. Is there a way to sort the Graph by SUM.VTotalHrs across the chart descending to ascending?

DEFINE FILE F4801
VTotalHrs/D12.2=J0.F3112.ACTUAL_SETUP_HOURS + J0.F3112.ACTUAL_RUN_LABOR + J0.F3112.ACTUAL_RUN_MACHINE ;
VStart/MDYY=F4801.F4801.COMPLETED ;
VStop/MDYY=F4801.F4801.COMPLETED ;
VDesc/A30=SUBSTR ( 30 , F4801.F4801.DESCRIPTION , 1 , 4 , 3 , 'VDesc' ) ;
END
GRAPH FILE F4801
-SET &SECTION='WHERE';
-INCLUDE swomfgo5/mrv/new_reporting_object.fex
-* Created by Info Assist for Graph
SUM SUM.VTotalHrs AS 'Work Center Hrs'
BY J0.F3112.A__BUISNESS_UNIT
WHERE F4801.F4801.BRANCH EQ ' 10160';
WHERE F4801.F4801.DESCRIPTION CONTAINS '&DESCRIPTION.Enter Description.';
ON GRAPH PCHOLD FORMAT PDF
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *

setReportParsingErrors(false);
setSelectionEnableMove(false);
setDepthRadius(5);
setCurveFitEquationDisplay(false);
setDisplay(getDataText(0),false);
setDisplay(getDataText(1),false);
setDisplay(getDataText(2),false);
setDisplay(getDataText(3),false);
------
setDisplay(getDataText(62),false);
setDisplay(getDataText(63),false);
setPlace(true);
setTextRotation(getO1Label(),1);
setTextString(getO1Title(),"Work Center");
setDisplay(getO1Title(),true);
setTextString(getY1Title(),"Total Hrs by Description");
setDisplay(getY1Title(),true);
ENDSTYLE
ON GRAPH SET STYLE *
INCLUDE=IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, ORIENTATION=LANDSCAPE, $
ENDSTYLE
END

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

Hi Dennis,

From our expert: if you want to display and sort by the same field, please try to drag the field to both the X and Y areas of the graph.

Cheers,

Kerry