I have a similar situation where I want to plot percent of total for a single item. If I select just that item, then I get the percent of total is 100% of the selected item. The way I got over this for plotting was to display the entire pivot table and then use data validation to select the item I wanted. Then use the offset command to find the item in the pivot table and make a named dynamic range out of it. I used this name in my charting.

This article has some information on dynamic charting: http://www.utteraccess.com/wiki/inde...namic_Charting.

In case you need additional information on the offset command, look here: http://www.utteraccess.com/wiki/inde...Dynamic_Ranges.