JYool
New member
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.
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 | $$$$$ | |||