Can this be done. I really need to vary the VAXSIS based on the number of employees to be plotted. At times there are 5 and at other times there are 100. Is it possible to query my final file, see how many employees there are and based on the number found set the VAXSIS?

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

Hi Robert, look at your previous thread ***CLOSED Reccomendation for graph of varying size...
You will have a start of solution.

To know the number of employee read your file first and then the number of employee. Sample using CAR:

TABLE FILE CAR
BY COUNTRY
ON TABLE HOLD
END
-RUN
-SET &VAXIS = IF &LINES GT 5 THEN 500 ELSE 300;

&LINES....forgot about that..thanks!