August 07, 2007, 09:00 AM
ShankarLine Graph - Axis Label
Hi
I am currently working on a line graph. In this I am displaying data sorted by two related fields
E.g. Displaying the number of cars sorted by the model name and model number. Say the model name-model number relation is as : Mercedes-1, Ferrari-2, BMW-3
Basically I want to display the model names in the order -Mercedes, Ferrari and BMW. But by default it displays them in alphabetical order. So I am using the model numbers too to sort the result. This orders the model names as desired but in the graph, the axis label is shown as a combination of both i.e 1:Mercedes, 2:Ferrari, 3:BMW.
However only the model names need to be displayed.
Or is there any way such that I can sort only by model names and still put them in desired order on the graph(which is not alphabetical order)
Please suggest some way to resolve this. Thank you.
August 07, 2007, 11:01 AM
FrankDutch
GRAPH FILE CAR
SUM SALES
ACROSS CAR
COLUMNS 'MASERATI' AND 'DATSUN' AND 'MERCEDES' AND 'BMW'
You can add all models you want even if not in the database.
August 08, 2007, 03:31 AM
ShankarHi Frank
Its working..thanks a lot!!