| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table- Show Data % of
The chart should show your pivot fields as a drop down at the bottom. You
should be able to de-select market potential as an option from there... HTH "Kellie" wrote: I have a pivot table where I am calculating the % of Market Share by using the maket potential and actual share. I have used the Show Data % of, and have performed the calculation however I now want to use this to make a graph, but the Market potential which is showing 100% is also showing up on my graphs. How can I keep the % calculation but hide the Market potential? I don't want to remove the pivot table and use just an excel chart as I have about 100 salesmen I am creating graphs for. thanks for the input. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show all data in pivot table | Excel Discussion (Misc queries) | |||
| how do i show text in the data field of a pivot table? | Excel Discussion (Misc queries) | |||
| How to show data greater than 10 in pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table - show items with no data | Excel Discussion (Misc queries) | |||
| Pivot table show pages but omit those without data | Excel Discussion (Misc queries) | |||
Hybrid Mode
