Issues

[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.

Please help.

skc

 

[Olly]

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


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.

Please help.

skc

 

[skc]

Olly,

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

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

Thanks.

 

[Peter Atherton]

SKC

Use Data, Subtotals and group the data by batch no. You
can find the Total, average and so on on each batch.

You might like to do a sort first on suppliers so that
groups are shown separately.

SubTotals can be collapsed to hide values use button 2 on
the left of the sheet (this only appears in Subtotal view)
to graph the data.

Alterately, you could create a Pivot Table and grouph this.

Regards
Peter

 

[Olly]

Mail me a copy of your workbook, I'll show you a couple of ideas.

--
Olly

Olly,

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

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

Thanks.

 

[skc]

sent...did you get it?

-----Original Message-----
Mail me a copy of your workbook, I'll show you a couple of ideas.

--
Olly

Olly,

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

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

Thanks.



.

 

[skc]

oly you are a star thanks!!!

-----Original Message-----
sent...did you get it?

.