Re: Issues

From: Olly (newsgroups2004-03_at_ollynet.com)
Date: 03/02/04 

Date: Tue, 2 Mar 2004 16:33:11 -0000

Would suggest creating a Pivot Table / Chart with the data, and providing
perhaps count of vehicles and average vehicle value per batch, along with a
date field. Could then produce charts showing trends in these values over
time, for each area as well as an overall chart. 

-- 
Olly
"skc" <anonymous@discussions.microsoft.com> wrote in message
news:5c0d01c4006e$5a3100e0$a101280a@phx.gbl...
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 *** 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.
Please help.
skc