pivot chart vba

So I have 3 worksheets that each have a number of pivot charts on them. The pivot data is on a different sheet than the pivot charts. Charts and Data are on separate sheets. I have a number of slicers (4) on each sheet too .... all three sheets have the same slicers so that if I make a change...

Hello, I have 3 Pivot tables each having rows and columns. The number of rows and columns changes according to slicers. Using a drop-down menu, I need to show on a chart (stacked columns) only 1 of the pivots. Meaning, I need to alter the source of the chart dynamical. How can I do it...

I have built my file in Access, ported to Excel and now opened Excel to add PivotTables. The pivot tables are working great. I added charts but both are showing the same; as though they are working off the same pivot table. I need the 2nd to work off the 2nd named pivot table. I call the code...

Element Type: Pivot Chart Issue: Slicers reformat Secondary Axis Attempted Solution: Below Macro, works up to a point Issue with Solution: When the "FullSeriesCollection" Expands or contracts error occurs- happens with new data or when using slicer [B]Mess of a Macro (what I wish I could...

Hi, I am using Excel 2010 on Windows 7. I have some pivot charts that have custom labels. When the workbook is first opened, I run the Sub called AddDataLabelAsValues. This is called a few times and runs through a few ChartSheets and assigns custom labeling to the columns. For each pivot...

I have written a code for creating pivot table. After this I want to add Chart which is linked to PT1 pivot table. and I should be able to give exact cell location where that chart should appear. Can anyone help how to do it? Its kinda urgent!!! Set data1 =...

Hi, I am using the following VBA code to move/fix a selected chart to a specific location on a worksheet. The code runs fine, but I end up with 2 duplicate charts: 1 in the new position, and the original chart in its original position. I would appreciate any help in how to fix the code to just...

In VBA coding is there a way to select the last two dates on a filter on a pivot table. These two dates will change every week so they need to be date variables. Lightamir

I have a pivot chart that displays the last 3 months of data onto a bar graph (eg, Since it is currently October, the graph shows Jul-Sep data). Instead of selecting the desired months manually , I would like to create a macro that will show the desired months every time the calender month...

Hello everybody: I have a question regarding a formula that I can´t get right. I want to do a macro for this but I think a pivot would be easier so I'm asking for your help. I have a big DB with several rows and columns. Column B has several card numbers (e.i. 7987654345678) Column C has a...

Hello, I am dealing with testing of software and not using any testing software for it but just sharepoints and excel. The problem we run into is having to deal with hand offs between testers and not knowing whats coming next for which work stream. I was wondering if it is possible to pivot...

Looking to build a report that retrieves trailing 3 months weekly files (sum ~ 12 files) from a directory and consolidates to 1 workbook. The files are labled EX DATA mmddyy.xlsx The files being retrieved from the directory have 3 tabs, only want to use data from the first tab labeled...

All, I have been using Debra Dalgleish's "Change All Pivot Tables With One Selection" macro, and it has been working fine. On Friday, I tried to apply it to a number of Pivot Charts and while the data elements were updating correctly, the charts would revert to default format. e.g. chart type...

Hi guys, I am new to Pivot Tables, I have managed to create a PT using the VBA (Thank MrExcel to help me understand the concept of PTs) I am trying to create a multiple Pivot Charts from 1 PT. But everytime I add a chart, it shows me everything in the chart. I really dunt want this. All...