How to display 2 pieces of data on one bar of a Pivot Chart?

J

J741

Hi.

My first attempt at using a Pivot Chart in Excel 2003 was to display a
graphical count of unique items in a column. It worked great for that
purpose and I can now see results like the following (displayed graphically
in a chart, of course)
Item1: 3000 items
Item 2: 250 items
Item 3, 10 items, etc.

But, what I want is a graphical display chart containing BOTH count and
percent, as follows:
Item1: 3000 items (92%)
Item 2: 250 items (7.7%)
Item 3, 10 items, etc. (0.3%)

Can this be done with Pivot Tables and Pivot Charts?


- James.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot chart - format issue 0
Countif or sumif for cumulative sums,pivot table & chart 2
How to give values to a range? 0
Pivot Table with Data Model Connection - getpivotdata #REF error 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
how to show the total in a pivot chart 1
How many pieces of trim molding to order? 0
always display rows in Pivot tables (show items with no data) 1

Top