Ok, figured out how to do it but using a macro after pressing F11 on one
table.

however, the dates are not corresponding to the data:
eg:

type1 has values in 01/06/07, 02/06/07, and 04/06/07
type2 has values in 01/06/07, 04/06/07, and 07/06/07


how can you make the data only show in the correct row on the chart? at the
moment it goes my the R2C2:R25C2 type of source.

I tried maiking it look at teh column with teh dates in (as I thought it
would read these to know what column to put teh data in) but it doesn't :(

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200707/1