Pivot Chart Data Selection

Q

questforexcel

Board Regular
Joined
Jan 18, 2019
Messages
128
Office Version
  1. 2013
Platform
  1. Windows
Hi,

Is it possible to deselect certain data from the Pivot Chat but which I would like to show in the Pivot Table.

I have tried to CTRL and select the required columns but chart takes in all the columns in the pivot chart field. If I delete the columns from the pivot chart it also deletes them from by pivot table.

Is it possible to have a dynamic pivot chart but with reduced or less fields than the pivot table.

On another chat, I would like to select only a few rows of the complete list on the pivot table. Is that possible?

Thank you,
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
You must log in or register to reply here.

Similar threads

B
  • Question
Why are separate pivot charts being filtered simultaneously?
Replies
4
Views
63
Alex Blakenburg
A
F
  • Question
Is there a way to edit data source in pivot charts
Replies
7
Views
197
Fanta0575
F
B
  • Question
Excel 2021 - Building a Pivot Table on a Filter Function Array
Replies
9
Views
190
BrerRabbit
B
O
  • Question
Help with percentages in a pivot table and chart
Replies
0
Views
298
Oddiewan
O
T
  • Question
How to *generate* data for a waterfall chart (not the chart itself)
Replies
0
Views
85
trippknightly
T

Forum statistics

Threads
1,214,798
Messages
6,121,635
Members
449,043
Latest member
farhansadik

Share this page

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
Back
Top