| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting 2 different pieces of data in 2 different columns | Excel Worksheet Functions | |||
| Chart/Graph to show 3 pieces of information | Charts and Charting in Excel | |||
| Date display in Pivot Chart | Charts and Charting in Excel | |||
| display cell value on a pivot chart | Charts and Charting in Excel | |||
| Can I display the actual data in the data field of a pivot chart? | Excel Discussion (Misc queries) | |||
Linear Mode
