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.
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 $$$$$
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.
Cool, glad you got it sorted!![]()
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
Bookmarks