Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Make click on Excel chart and automatically a new WorkBook is open with the chart's pivot table

Posted on 2014-01-23
5
Medium Priority
?
400 Views
Last Modified: 2014-01-25
I have a excel file in which I have 5 pivots tables and its charts.

Pivot tables are in sheet2 and charts are in sheet1.

What I want to do is to make click on one chart and then automatically the chart's pivot table is shown in a new workbook. A new workbook with only one pivot table.
0
Comment
Question by:acunaara
  • 3
  • 2
5 Comments
 
LVL 31

Expert Comment

by:gowflow
ID: 39805761
Could you post this workbook that have the charts linked to the pivot ?
gowflow
0
 

Author Comment

by:acunaara
ID: 39807203
The info is confidential but I made an example of what I want to do.

Please see attach file
Pivot-and-Chart.xlsm
0
 
LVL 31

Accepted Solution

by:
gowflow earned 2000 total points
ID: 39807911
Is this what your looking for ??

I created 2 other charts but not pivot
I removed the link you had on the chart to point to a macro and instead created a button htat hold a code that will call a macro in the module.

Please test it and check the result. It will only work on Pivot as this is what you requested.

Let me know your comments.
gowflow
Pivot-and-Chart-V01.xlsm
0
 

Author Closing Comment

by:acunaara
ID: 39808056
Thank you dude

This is very useful!!
0
 

Author Comment

by:acunaara
ID: 39809708
Just in case:

The TableRange1 property doesn't include page fields. So, I just changed it to TableRange2.

http://msdn.microsoft.com/en-us/library/office/aa215737(v=office.11).aspx

Kind regards and many thanks
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question