Pivot Charts

[Sharkie21]

Basically I want to create a pivot chart from my pivot table, but only want one of the data categories. Currently my pivot table has number of "green balls", "total number of balls", frequency "green/total" I want to create a pivot chart that reflects only the frequency, however if I change the data to have only frequency checked my pivot table loses the other two columns, (number of green) and (total number). How can I do this without my table losing it's other columns?

Thanks

 

[Jon Peltier]

A pivot chart charts exactly the data in the pivot table. You can make two independent pivot tables, or you can make a regular chart from the pivot table. Select a blank cell located away from the pivot table, and start the chart wizard. In step 1, select the chart type you want. In step 2, click on the Series tab, and enter each series and its parameters here.