Make a pivot table of your data, with date in the rows area, type in the
columns area, and value in the data area. Make a stacked bar chart of this
table. You might try a clustered bar as an alternative to the stacked bar. I
would also recommend a 2D chart, which shows the data more clearly, with
less clutter and distortion, than the 3D version.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"OTWarrior via OfficeKB.com" <u33269@uwe wrote in message
news:74a9faf5e11c8@uwe...
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