Re: Issues

From: skc (anonymous_at_discussions.microsoft.com)
Date: 03/02/04 

Date: Tue, 2 Mar 2004 08:44:30 -0800

Olly,

That sounds absolutely fantastic - but I do not know where
to start!

Please can you give me step-by-step pointers.

Thanks.

>-----Original Message-----
>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
>
>
>.
>