Am I missing something?

JYool

New member
Joined
Aug 24, 2011
Messages
17
Reaction score
0
Points
0
Location
Courtenay, BC, Canada
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.
dateproductsum of total
Sep-10
Prod A$$$$$
Prod B$$$$$
Oct-10
Prod A$$$$$
Prod B$$$$$
 
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.
 
Back
Top