I have three colums, one data column, IR and two catagories, circuit
and treatment. I want to have a bar chart with the IR data in the y
axis, Treatment as the X axis with the data in two series, Short and
Long so that Base, Short and Long are presented beside each other
etc. All I can get is everything in one long series all the short
data then all the long data. It seems like this was pretty simple in
2003 but we have
upgraded" to Office 2007 and alot of the norms of charting have been
left in the dust.

The following data has been trimed to simplify...
Circuit Treatment IR
short Base 100.00E+9
short Wet 100.00E+9
short 1Cut 100.00E+9
long Base 100.00E+9
long Wet 100.00E+9
long 1Cut 100.00E+9