Focal Point
[CLOSED] Change the order in which the data gets displayed along the stacked bar

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/936106843

January 22, 2010, 06:58 AM
Priya
[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
Priya

This 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