Graph Builder: How do I only display categories with values for each group x

jac865

here's what i've got:

clearly i don't want to display all treatments for each experiment. D and E were not in experiment 1 and A-C were not in experiment 2. how do i display only treatments with values?

-->

treatment	experiment	value
A	1	0.97
A	1	0.39
A	1	0.49
A	1	0.44
A	1	0.38
B	1	0.73
B	1	0.72
B	1	1.02
B	1	0.07
B	1	0.09
C	1	0.23
C	1	0.2
C	1	0.1
C	1	0.22
C	1	0.07
D	2	0.29
D	2	0.18
D	2	0.13
D	2	0.57
D	2	0.86
E	2	0.68
E	2	0.34
E	2	0.46
E	2	0.71
E	2	0.5

 

help?

txnelson

You can get the results by having a 2 level x axis and Overlaying by treatment

Graph Builder(
	Size( 531, 464 ),
	Show Control Panel( 0 ),
	Variables(
		X( :experiment ),
		X( :treatment, Position( 1 ) ),
		Y( :value ),
		Overlay( :treatment )
	),
	Elements( Bar( X( 1 ), X( 2 ), Y, Legend( 13 ) ) )
);