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.
|