JYool
2011-11-21, 07:06 PM
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
$$$$$
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
$$$$$