I am new to Pivot Charts so I am hoping someone can help me with this. I have
a bar chart something like the following. I am using Excel 2003.



Amount


Cat 1 Cat 2 Cat 3 Cat 1 Cat 2 Cat 3
2007 2008

What I need to know is how do I get the bars for each year together with no
spaces. In other words, I would have a group or set of 3 bars and then a
space and then another set of 3. Also, if possible, make each Cat a different
color.

is this possible?

Thanks in advance!