pivotcharts

Hi all, Hi all, Pretty to power BI charting and eager to learn and be involved in the community =) First i will show what i did previously using powerquerry and pivot chart in excel 2016 and then i show where i am stuck in powerBI Basically i have a simple table querry from SQL...

Hi all, Wondering if this is even possible... Is it possible to set up a slicer so if when items is selected, the colour be synchronizes to the PivotCharts 'line' the Slicer is linked to? Furthermore, can this be applied to when multiple selections are made? E.g. Three people, Three names...

Hi I want to insert some pivotcharts and charts to userform in Microsoft Excel 2013 visual basic for application. Would you please help me on this ? Thank you in advance.

I have one data source with multiple columns - for the purpose of this question, the column I'm concerned about is Category. The Category has several choices available - Cat 1, Cat 2, Cat 3, Cat 4, Cat 5, Cat 6 & Cat 7. I need to display scores from Cat 1, 2, 3 and 5 as a pie chart, so I have...

I have 2 sheets in Excel. Sheet 1 is my pivot table and Sheet 2 is the Pivotchart linked to the pivot table. What I need is to add different images on to the Pivotchart but which image to insert depends on what value has been selected in the pivot table filter. Any ideas how to write this code...

I know you can add subtotals in pivot tables, but can you add subtotals in pivot charts? Below is a small sample data. I would like a subtotal in chart for the Report Year. Thank you. Report filters: None Legend Fields (Series): Type Axis Fields (Categories): Report Year Values: Sum of Values...

Hi All, This is my first steps on VBA in Excel 2010 and I face a bit of a challenge, I hope someone will be able to help. I am treating with data concerning different factories having different production lines. Per factory, I am displaying 33 pivots charts next to their respective Pivot...

Pivots and Charts reopen as text: ie cant open the Field List etc... Have no links/cubes etc as stated in other posts on the net. When opening from an email (sent the sheet to someone before closing it the first time) it works but after closing excel and opening it later they are all broken. I...