Pivot Table- Show Data % of

K

Kellie

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

Sean Timmons

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
 

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 table chart 7
Average of % in pivot table 1
pivot table data 2
Question on the occupied field of the pivot table in excel spreadsheet 0
Problem with Calculated item in Pivot Table 1
hide pivot table 3
Pivot table to query data in a set range 3
Pivot Table Data 2

Top