Am I missing something?

[JYool]

Using office 2007, and picot tables I'm trying to create a bar chart from a pivot table which includes filtered data from a large table full of irrellevant information... what I have in my pivot table is essentially the following table:

when i go to chart it, it has the product type as an axis category, which is fine, but i want it to let me make Product A red and Product B blue (for instance)

i have no idea why i don't know how to do this.
Can someone offer a tip? There's a lot of date, and it would be very involved to scrub it to post an actual worksheet.

date	product	sum of total
Sep-10
	Prod A	$$$$$
	Prod B	$$$$$
Oct-10
	Prod A	$$$$$
	Prod B	$$$$$

[JYool]

I knew i was missing something. i just had to move the categories to the column instead of row headings and it all made sense.

[Ken Puls]

Cool, glad you got it sorted!