[CLOSED] Change the order in which the data gets displayed along the stacked bar
I am creating a stacked chart.
GRAPH FILE CAR SUM SALES ACROSS COUNTRY BY BODYTYPE ON GRAPH SET LOOKGRAPH VBRSTK1 ON GRAPH SET GRAPHEDIT SERVER ON GRAPH SET BARNUMB OFF ON GRAPH SET 3D OFF ON GRAPH SET VZERO ON ON GRAPH SET GRID ON ON GRAPH SET GRMERGE ON END
For ITALY (along the X axis) SALES (Y axis) is being segregated by BODYTYPE in this order (COUPE,ROADSTER,SEDAN)from bottom of the bar to top. Sales for COUPE => 12,400 ROADSTER => 13,000
SEDAN => 4,800 Is it possible to change this order ? Say first SEDAN then COUPE and finally ROADSTER ?
Thanks PriyaThis message has been edited. Last edited by: Kerry,
769 Windows
Using all the above
January 22, 2010, 08:43 AM
Danny-SRL
-* File Priya01.fex
GRAPH FILE CAR
SUM SALES
ACROSS COUNTRY
BY BODYTYPE ROWS SEDAN OVER COUPE OVER ROADSTER OVER HARDTOP OVER CONVERTIBLE
ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET GRMERGE ON
END
You can use this, however the legend is somewhat cryptic...
Another possibility:
-* File Priya01.fex
DEFINE FILE CAR
MYBODY/A30=DECODE BODYTYPE(SEDAN '1-SEDAN' COUPE '2-COUPE' ROADSTER '3-ROADSTER' HARDTOP '4-HARDTOP' CONVERTIBLE '5-CONVERTIBLE');
END
GRAPH FILE CAR
SUM SALES
ACROSS COUNTRY
BY MYBODY
ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET GRMERGE ON
END
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF