S
skc
Hi
I am using Excel 2000 and wish to know how I can graph
some data.
The data is car data, these arrive in batches - assigned
by a batch number. The batches differ in size, one batch
could have 20 records, yet another could have 3. The
values of the cars differ too.
The whole emphasis here is to find out how much (money-
wise) cars have been issued in the batches, and find out
whether they are getting less and less.
I want to create normalised graphs and %'ages of total
amounts within the batch - as I feel that the cars we are
receiving are worthless compared to before. What I mean
by this is that Batch 1-3 were high valued cars, such as
Mercedes, and now we are getting run-of-the-mill cheapies -
such as Fords that are 1/3 of the price of a Mercedes -
hence why this is affecting our profits - we make higher
profits on the bigger cars.
My Excel sheet has these fields:
1. Batch Number : e.g. 001
2. Area where vehicle came from : AB3
3. Value of the vehicle : £20,000
I have not got a batch count field - as I said earlier,
batches are of different sizes, they could be 20, 2, 43
etc...
What graphs can I make or additional mathematical formulae
to make my results look professional, as I know for a fact
that our supplier is now passing onto us rubbish cars.
I need some stats fields and normalised graphs etc... but
I do not know where to start - I need help!!
Please help.
skc
I am using Excel 2000 and wish to know how I can graph
some data.
The data is car data, these arrive in batches - assigned
by a batch number. The batches differ in size, one batch
could have 20 records, yet another could have 3. The
values of the cars differ too.
The whole emphasis here is to find out how much (money-
wise) cars have been issued in the batches, and find out
whether they are getting less and less.
I want to create normalised graphs and %'ages of total
amounts within the batch - as I feel that the cars we are
receiving are worthless compared to before. What I mean
by this is that Batch 1-3 were high valued cars, such as
Mercedes, and now we are getting run-of-the-mill cheapies -
such as Fords that are 1/3 of the price of a Mercedes -
hence why this is affecting our profits - we make higher
profits on the bigger cars.
My Excel sheet has these fields:
1. Batch Number : e.g. 001
2. Area where vehicle came from : AB3
3. Value of the vehicle : £20,000
I have not got a batch count field - as I said earlier,
batches are of different sizes, they could be 20, 2, 43
etc...
What graphs can I make or additional mathematical formulae
to make my results look professional, as I know for a fact
that our supplier is now passing onto us rubbish cars.
I need some stats fields and normalised graphs etc... but
I do not know where to start - I need help!!
Please help.
skc