Pivot Table Charting Help
March 30, 2006 4:21 AM Subscribe
Help me with creating two bar charts from two columns in one pivot table, please?
posted by dantodd to Computers & Internet (4 answers total)
I'd like to create a single worksheet that has two charts on it. One chart will show a breakdown of product groups sold in the last year while the other will show the same kind of breakdown for the previous year. I can get the data in to two columns in a pivot table. I have no control over the format of the source data and there is too much of it to massage it into shape.
One difficulty is that I will be running this as a report for a number of different customers. They do not all stock the same product groups. For example, customer 1 stocks widgets a,b,c and d but customer 2 only stocks widgets a and b. This means that the pivot tale will always be a different length so a manual chart for each is out of the question.