Pivot Charts

Sharkie21

Active Member
Joined
Nov 2, 2005
Messages
319
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
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
5,135
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,499
Messages
5,832,067
Members
430,109
Latest member
tinezi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top