I have a table with 3 columns, the first being the date, second being the
type of recording, and the 3rd being the amount of that type that happened on
that day

04/06/2007 type1 2
04/06/2007 type2 26
04/06/2007 type3 9
04/06/2007 type4 9
04/06/2007 type5 1
05/06/2007 type1 2
05/06/2007 type4 39
05/06/2007 type5 19
05/06/2007 type6 19
05/06/2007 type7 2
06/06/2007 type2 1
06/06/2007 type4 20
06/06/2007 type5 11
06/06/2007 type7 10

I would like to create chart based on this, which show the date in the y axis,
the total ammount in the x axis, and each coloured segment as the type (in a
stacked bar 3d chart)

which of the columns to i select at which point? as I have tried many
variations, and I either get the data without the dates, with no values, or
it wont let me add another series.

This chart also needs to be dynamic (so it looks for "type1" in the second
column and makes that a series). Is this possible?

This is to be used in a report to show how the business is working, and what
types are more successful.

--
Message posted via http://www.officekb.com