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
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,933
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,002
Messages
5,575,488
Members
412,669
Latest member
nickyon1
Top