PIVOT TABLE + CHART - Pasting Special Values making Pivot Chart Blank

gazwilliamson

New Member
Joined
Jun 4, 2019
Messages
9
Hello all,

We have one pivot table where we are seeing a recurring issue - this does not happen with any other pivot tables on the tab.

I am trying to paste+special values on the pivot table so it removes the link to source data, and will then leave me with a graph.

This seems to work for any other pivot table+chart but this one has now been removing everything on the chart after the paste+special v

Any ideas why this would be happening with just this graph?

Thanks in advance
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

GraH

Well-known Member
Joined
Mar 22, 2020
Messages
979
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hi,

I was unaware one could do that. In my experience when you replace a pivot with values, the pivot chart looses his source data. Hence returns a blank canvas. However I just tried it and indeed the chart is still there.
However it has lost its "source" link: the data series are somehow replaced by a hardcoded array string.
Somehow I do not see the advantage of doing this.

Can't you simply use one of these setting? (uncheck them?)
1623504146762.png
 

Forum statistics

Threads
1,143,622
Messages
5,719,796
Members
422,244
Latest member
AYSHANA

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