chart help please

[jvoortman]

I have a worksheet which shows all the purchases made by a
customer over an extended period of time. Can someone tell
me how to make a "chart" which (hopefully) will show a
line starting on left and heading northbound as it moves
to the right (sort of like what you see when they show the
price of gasoline on the nightly news). I have posted the
dat here http://bbdldarts.homestead.com/excelexample.html,
and I also put commas between columns of info.
It would be nice if I could get a chart that breaks it
down by product and dat, not just total products.
please help if you can

 

[jvoortman]

I can email the file if anyone has an idea they want to
try with the data

 

[AlfD]

Hi!

Can you put a suitable selection of data on this page?
Are you looking for a cumulative graph (adding on each year'
purchases, for example? or even each individual purchase?)
Have you any issues with price base over a prolonged period? (Mos
people have )
Do you want to do it with blocks or lines)

Al

 

[jvoortman]

thanks for your response Alf,

I guess what I want to do is get a line graph/chart that
would show the purchases by product over a period (say 1
year) and tht way I could put one chart on top of another
to see if a customer is buying more or less than other
years

 

[jvoortman]

invoice date , product code , Quantity
, Unit
21/01/03 , 07-1150 , 80.0000 ,
Case
21/01/03 , 03-1125 , 10.0000 ,
Case
21/01/03 , 07-0500 , 10.0000 ,
Case
21/01/03 , 01-1125 , 10.0000 ,
Case
21/01/03 , 03-1125 , -10.0000 ,
Case
21/01/03 , 01-2250 , -2.0000 ,
Case
04/02/03 , 01-0750 , 5.0000 ,
Case
04/02/03 , 03-1125 , 10.0000 ,
Case
04/02/03 , 07-0410 , 5.0000 ,
Case
04/02/03 , 01-0750 , -5.0000 ,
Case
04/02/03 , 03-1125 , -10.0000 ,
Case
04/02/03 , 07-0410 , -5.0000 ,
Case
04/02/03 , 01-0750 , 5.0000 ,
Case
04/02/03 , 03-1125 , 10.0000 ,
Case
04/02/03 , 07-0410 , 5.0000 ,
Case
17/02/03 , 01-0750 , 2.0000 ,
Case
17/02/03 , 01-1125 , 24.0000 ,
Case
17/02/03 , 03-1125 , 2.0000 ,
Case
17/02/03 , 07-0600 , 40.0000 ,
Case
17/02/03 , 07-1150 , 40.0000 ,
Case
17/03/03 , 01-1125 , 15.0000 ,
Case
17/03/03 , 03-1125 , 10.0000 ,
Case
11/04/03 , 01-0750 , 5.0000 ,
Case
11/04/03 , 01-1125 , 20.0000 ,
Case
11/04/03 , 03-1125 , 15.0000 ,
Case
11/04/03 , 07-0500 , 10.0000 ,
Case
11/04/03 , 07-0600 , 40.0000 ,
Case
11/04/03 , 07-1150 , 40.0000 ,
Case
17/04/03 , 8032 , 1.0000 ,
Each
02/05/03 , 01-1125 , 5.0000 ,
Case
02/05/03 , 03-1125 , 5.0000 ,
Case
02/05/03 , 07-0500 , 15.0000 ,
Case
21/05/03 , 03-2250 , 10.0000 ,
Case
21/05/03 , 07-0500 , 5.0000 ,
Case
21/05/03 , 07-1150 , 40.0000 ,
Case
02/06/03 , 01-0750 , 10.0000 ,
Case
02/06/03 , 01-1125 , 15.0000 ,
Case
02/06/03 , 07-0410 , 5.0000 ,
Case
02/06/03 , 07-0500 , 10.0000 ,
Case
02/06/03 , 07-0600 , 40.0000 ,
Case
09/06/03 , 01-0750 , 6.0000 ,
Case
09/06/03 , 01-1125 , 6.0000 ,
Case
09/06/03 , 07-0410 , 8.0000 ,
Case
09/06/03 , 07-0500 , 8.0000 ,
Case
03/07/03 , 07-1150 , 40.0000 ,
Case
03/07/03 , 01-0750 , 3.0000 ,
Case
03/07/03 , 01-1125 , 25.0000 ,
Case
03/07/03 , 03-1125 , 6.0000 ,
Case
03/07/03 , 03-2250 , 2.0000 ,
Case
03/07/03 , 07-0410 , 2.0000 ,
Case
03/07/03 , 07-0500 , 10.0000 ,
Case
09/07/03 , 03-1125 , 6.0000 ,
Case
09/07/03 , 07-0500 , 12.0000 ,
Case
09/07/03 , 4035 , 1.0000 ,
Each
09/07/03 , 8032 , 1.0000 ,
Each
22/07/03 , 4035 , 1.0000 ,
Each
22/07/03 , 8032 , 1.0000 ,
Each
01/08/03 , 01-0750 , 5.0000 ,
Case
01/08/03 , 01-1125 , 15.0000 ,
Case
01/08/03 , 03-1125 , 5.0000 ,
Case
01/08/03 , 07-0500 , 25.0000 ,
Case
01/08/03 , 07-0600 , 40.0000 ,
Case
01/08/03 , 07-1150 , 40.0000 ,
Case
29/08/03 , 01-1125 , 24.0000 ,
Case
29/08/03 , 4035 , 1.0000 ,
Each
29/08/03 , 07-0600 , 10.0000 ,
Case
29/08/03 , 07-1150 , 20.0000 ,
Case
29/08/03 , 8032 , 1.0000 ,
Each
02/09/03 , 01-1125 , 5.0000 ,
Case
02/09/03 , 03-1125 , 5.0000 ,
Case
02/09/03 , 07-0500 , 10.0000 ,
Case
08/09/03 , 01-1125 , 10.0000 ,
Case
08/09/03 , 03-2250 , 3.0000 ,
Case
08/09/03 , 07-0410 , 3.0000 ,
Case
08/09/03 , 07-0500 , 10.0000 ,
Case
08/09/03 , 07-0600 , 40.0000 ,
Case
08/09/03 , 4035 , 1.0000 ,
Each
08/09/03 , 8032 , 1.0000 ,
Each
26/09/03 , 01-0750 , 5.0000 ,
Case
26/09/03 , 03-1125 , 5.0000 ,
Case
26/09/03 , 07-1150 , 40.0000 ,
Case
20/10/03 , 01-1125 , 5.0000 ,
Case
20/10/03 , 03-1125 , 5.0000 ,
Case
20/10/03 , 07-0500 , 15.0000 ,
Case
22/10/03 , 03-2250 , 5.0000 ,
Case
27/10/03 , 01-0750 , 2.0000 ,
Case
27/10/03 , 03-1125 , 10.0000 ,
Case
27/10/03 , 03-2250 , 2.0000 ,
Case
27/10/03 , 07-1150 , 40.0000 ,
Case
24/11/03 , 01-1125 , 20.0000 ,
Case
24/11/03 , 07-0500 , 10.0000 ,
Case
24/11/03 , 07-0600 , 40.0000 ,
Case
01/12/03 , 01-0750 , 5.0000 ,
Case
01/12/03 , 01-1125 , 20.0000 ,
Case
01/12/03 , 03-1125 , 10.0000 ,
Case
01/12/03 , 03-2250 , 5.0000 ,
Case
01/12/03 , 07-0500 , 15.0000 ,
Case
01/12/03 , 07-1150 , 40.0000 ,
Case
17/12/03 , 4035 , 2.0000 ,
Each
19/12/03 , 01-0750 , 5.0000 ,
Case
19/12/03 , 03-1125 , 15.0000 ,
Case
19/12/03 , 07-0410 , 5.0000 ,
Case

 

[jvoortman]

here is a chart I found on the internet that is kind of
what I'm looking for as an end result.
http://master.debian.org/~ajt/graph.png
I am showing you this instead of trying to name it and
confusing the isue even more

 

[AlfD]

Hi!

Well, you can certainly graph this data and get something like yo
suggest (though one data series = one line at this stage).

Add a column which gives cumulative totals for "Quantity".
(Easy way is set E2=C2 (where Quantity resides)
Then set E3=E2+C3 and copy this down).

Now select column A (dates) and, with ctrl depressed, select column E.
If your version of Excel jibs at this, you may find it useful to mov
the columns so that they are contiguous; then select both columns o
data.
Click the Chart wizard button and choose a line graph.

Does this get you started?

By the way, your web address didn't work for me.

Al

 

[Gord Dibben]

Quite impressive.

Do you have a question?

If this is a posting to a previous thread, please go back to that thread.

Gord Dibben Excel MVP