create a PivotTable based on a PivotChart ! (2013)

L

lalbatros

Well-known Member
Joined
Sep 5, 2007
Messages
659
Hello,

I enjoy quite a lot, in xl2013, the possibility of creating PivotCharts without any associtated PivotTable.
However, from time to time I would like to explore the data from a PivotChart within a (temporary) PivotTable.

Would you know of some clever macro that would just do that?
Would that be possible?

It would be very helpful because it can be time consuming to re-built a PT based on a given PC!
This is because all the fields have to be placed correctly with their -sometimes complicated- selections.

Thanks,

Michel
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Sort by date Sort by votes
<html>

<head>
****** http-equiv=Content-Type content="text/html; charset=windows-1252">
****** name=Generator content="Microsoft Word 14 (filtered)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin-top:0in;
margin-right:0in;
margin-bottom:10.0pt;
margin-left:0in;
line-height:115%;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
.MsoChpDefault
{font-family:"Calibri","sans-serif";}
.MsoPapDefault
{margin-bottom:10.0pt;
line-height:115%;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
-->
</style>

</head>

<body lang=EN-US>

<div class=WordSection1>

<p class=MsoNormal>Hi!</p>

<p class=MsoNormal>In Excel 2013, you can do that from the Ribbon:</p>

<p class=MsoNormal style='text-indent:.5in'><b>INSERT / Charts / PivotChart /
PivotChart</b></p>

<p class=MsoNormal>This opens the <b>Create PivotChart</b> popup.<br>
There, most of the time, I select:</p>

<p class=MsoNormal style='text-indent:.5in'><b>Use an external data source</b></p>

<p class=MsoNormal>followed by:</p>

<p class=MsoNormal style='text-indent:.5in'><b>Choose Connection...</b></p>

<p class=MsoNormal>This opens the <b>Existing Connections</b> popup/.<br>
There, I chose the <b>Tables</b> tab and select the table I wish.</p>

<p class=MsoNormal>Alternatively, in the <b>Create PivotChart</b> popup, you
could select a table and then select the option:</p>

<p class=MsoNormal style='text-indent:.5in'><b>Add this data to the Data Model</b></p>

<p class=MsoNormal><br>
I observed that it is the existence of a Data Model in the workbook that makes
it possible to create PivotCharts without any PivotTable. This is the only
reason why I finally switched to Excel 2013 !!! It relieved me of the burden of
maintaining some 100 useless PivotTables.</p>

<p class=MsoNormal>However, from time to time I need to see a PivotChart as a
PivotTable in order to understand what is behind and check if I made some
mistakes. It could also be useful during meetings.</p>

<p class=MsoNormal>For this reason a quick way to generate the PivotTable from
a PivotChart would be a very useful feature/tool.</p>

<p class=MsoNormal>Thanks for any suggestion!</p>

<p class=MsoNormal>Michel</p>

</div>

</body>

</html>
 
Last edited:
Upvote 0
<html>

<body lang=EN-US>

<div class=WordSection1>

<p class=MsoNormal>Hi!</p>

<p class=MsoNormal>In Excel 2013, you can do that from the Ribbon:</p>

<p class=MsoNormal style='text-indent:.5in'><b>INSERT / Charts / PivotChart /
PivotChart</b></p>

<p class=MsoNormal>This opens the <b>Create PivotChart</b> popup.<br>
There, most of the time, I select:</p>

<p class=MsoNormal style='text-indent:.5in'><b>Use an external data source</b></p>

<p class=MsoNormal>followed by:</p>

<p class=MsoNormal style='text-indent:.5in'><b>Choose Connection...</b></p>

<p class=MsoNormal>This opens the <b>Existing Connections</b> popup/.<br>
There, I chose the <b>Tables</b> tab and select the table I wish.</p>

<p class=MsoNormal>Alternatively, in the <b>Create PivotChart</b> popup, you
could select a table and then select the option:</p>

<p class=MsoNormal style='text-indent:.5in'><b>Add this data to the Data Model</b></p>

<p class=MsoNormal><br>
I observed that it is the existence of a Data Model in the workbook that makes
it possible to create PivotCharts without any PivotTable. This is the only
reason why I finally switched to Excel 2013 !!! It relieved me of the burden of
maintaining some 100 useless PivotTables.</p>

<p class=MsoNormal>However, from time to time I need to see a PivotChart as a
PivotTable in order to understand what is behind and check if I made some
mistakes. It could also be useful during meetings.</p>

<p class=MsoNormal>For this reason a quick way to generate the PivotTable from
a PivotChart would be a very useful feature/tool.</p>

<p class=MsoNormal>Thanks for any suggestion!</p>

<p class=MsoNormal>Michel</p>

</div>

</body>

</html>
 
Upvote 0
noted, because those are external source, a PT is not created in the process.
I know how to retrieve raw data from a PT but not a PT from a PChart... Sorry.
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question
VBA copy data from multiple workbooks based on criteria
Replies
6
Views
2K
Jendjieh
J
F
  • Question
Can't paste when using method to filter a Pivottable based on cell value
Replies
3
Views
550
Flux1234
F
T
  • Solved
VBA to insert rows based on cell value compared to array
Replies
2
Views
2K
tjdickinson
T
D
  • Question
Method 'Intersect' of object'_Application' failed
Replies
6
Views
1K
Anthony47
A
C
  • Solved
Create a macro using Find and Replace with SUBSTITUTE referencing the ActiveCell address
Replies
5
Views
568
JLGWhiz
JLGWhiz

Forum statistics

Threads
1,203,236
Messages
6,054,298
Members
444,715
Latest member
GlitchHawk

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