Hello

From the below sample graph request, is there a way for me to print car values instead of country values on the X axis

GRAPH FILE CAR
SUM
DEALER_COST
RETAIL_COST
SALES
ACROSS COUNTRY NOPRINT
ACROSS CAR AS ''
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET 3D OFF
ON GRAPH SET VAXIS 385
ON GRAPH SET HAXIS 600
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 2
ON GRAPH SET GRXAXIS 2
WHERE COUNTRY IN ('ENGLAND','JAPAN')
END
-RUN
-EXIT

Your help is greatly Appreciated.
Thanks

This message has been edited. Last edited by: <Emily McAllister>,

Use a BY, not an ACROSS:

GRAPH FILE CAR
SUM
	DEALER_COST 
	RETAIL_COST 
	SALES 
BY COUNTRY NOPRINT
BY CAR AS ''
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET 3D OFF
ON GRAPH SET VAXIS 385
ON GRAPH SET HAXIS 600
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 2
ON GRAPH SET GRXAXIS 2
WHERE COUNTRY IN ('ENGLAND','JAPAN')
END
-RUN
-EXIT

But I want the two graphs on the same X and Y coordinates. I am expecting a X axis with first England and its car values followed by Japan and its car values.

Oh ! This is something different and I don't think that it will be feasible with out of the box bar graph (except if you, maybe, pre-defines the data to result in one number by the country and one by the car : which may result in "two" bar where having proper "real" by field. But I'm really not sure of that and may need some bunch of coding).

I think that it is better to change your graph format. You have many other format where you can display two different by/measure on the same graph. Explore the possibilities.