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

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.

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

Anyone know how to do this?


"J741" wrote:

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.