pivot table charts

  1. M

    Excel Pivot table status dashboard - separate grouped columns

    Hello, I am trying to make a dashboard for one of my collegues which will determine if so called 'LS' and 'FS' deliverables are reviewed and delivered in time. Those deliverables have to be made for about 30 different customers. I already made the sheet where they fill in the due date and when...
  2. D

    Pivot chart changes data source when slicer is changed

    Hi guys, I've Googled but I haven't been able to find any posts about my problem. I have imported data directly from a Teradata database and imported it as a "PivotTable Report" and not as "Table". The data is about 300,000 rows which is why I'd prefer not to import this as a "Table" as it...
  3. T

    How to create a dynamic macro coding to create pivot table

    Could you please tell me VBA coding that I can use to create a dynamic pivot table on a new sheet? Below is the sample dataset that I want to create pivot table with. Promotion Name Product Code DC(/Unit) LG SP-2015Q3-SPIFF-STUDIO-001 LSSG3016ST.BSTESTD 75 LG SP-2015Q3-SPIFF-STUDIO-001...
  4. K

    How to combine multiple columns into one reportable chart??

    Hi All,</SPAN> I have searched high and low, so apologies if this has been asked before.</SPAN> I am not sure if I am pushing Excel further then what it is cable of</SPAN> I have a work book with a table that goes from A12 to Z468 that is used for reporting purposes. </SPAN> My header row...
  5. M

    Pivot Table Charts - Cum Count starts over every year

    Basically I’m pulling in data from a DB for this chart. I need to create pivot table chart that has a cumulative sum of various status’ from year to year. The problem I’m running into is that it stops the cumulative sum after 2009 and starts over at 2010. I need it to keep cumulative sum from...

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