Hi,

Is it possible to show all the values in the column in different colour in the bar.

for eg: the Table with data

Type VALUE
missing 3
missing 2
non-unique 1
non-unique 0
unique parent 1
unique parent 3

If i create a bar graph with "Type" as X axis and value in Y axis(sum)

Can the Bar graph for the Type "missing" can show upto value 3 in different colour and "2"
in different colour ...(like stack graph).

Thanks in Advance..

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

Allen...I don't think we understand what you are asking for here?

Prarie...

I want to create a bar graph...with the field "Type" as X axis and field "VALUE" as Y axis.

(table value given i previous post)

Code like ..

GRAPH FILE TEST
SUM VALUE
ACROSS Type

Which will give me a seperate bar for all the values in the field "Type"..Like "missing" will be of Height 5....In this i want bar of Height 5 to show two diffrent colour for "3" and "2" because missing is 3+2=5....

Thanks and sorry for the inconvience..

Allen,

In your example for each value of TYPE you show 2 occurences of VALUE. Is this always the case? Or can there be more than 2? and how many more?

The reason for this question is that in order to show a multicolored bar, you have to have different fields which you can stack.

Following is an example using the CAR file. The variable &FLD is assigned a field name to plot (here the HEIGHT field; you can change this to any numeric field in CAR). By using ACROSS a number of fields is created for each value of HEIGHT in this example and held int the ALLEN file
CHECK FILE ALLEN HOLD creates a HOLD file with, among other things, the list of fields in the ALLEN file. The ASNAMES parameter gives names to the different HEIGHT fields using the first 3 letters of the field name: HEI. By TABLEing the HOLD file you get a list of all the HEIGHT fields which can be saved and the included in the GRAPH command.
Lastly you create a stacked graph.

  
-* File Allen1.fex
-SET &FLD='HEIGHT';
-SET &FLD3=EDIT(&FLD, '999');
SET HOLDLIST=PRINTONLY, ASNAMES=ON
-* First request: create all the HEIGHT fields according to the values of HEIGHT
TABLE FILE CAR
SUM FST.&FLD
BY COUNTRY
ACROSS &FLD
ON TABLE HOLD AS ALLEN
END
-* Second request: list all the HEIGHT fields and save them in a FEX
CHECK FILE ALLEN HOLD
FILEDEF FLDS DISK FLDSS.FEX
TABLE FILE HOLD
PRINT FIELDNAME
IF FIELDNAME CONTAINS &FLD3
ON TABLE SAVE AS FLDS
END
-RUN
-* Third request: graph and stack the HEIGHT fields
GRAPH FILE ALLEN
SUM 
-INCLUDE FLDS
ACROSS COUNTRY
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 PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setSeriesType(0,1);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(false);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
$
ENDSTYLE
END

Good luck

This message has been edited. Last edited by: Danny-SRL,

Allen,

Did you manage with your multi-colored graph?