Forum

Hi Maya, To be fair to the pie, they're ok for 2 or 3 series that are significantly different in size since it'll be easy to compare the segments t...

Hi Marc, It sounds like you need to take these snapshots at regular intervals (daily, weekly, monthly, whatever frequency you want) and add that da...

Hi Oleg, Ken Puls does a great job of explaining what's going on here and a solution in this post: Let me know if you get stuck. Mynda

Hi Anthony, Unfortunately this is a known bug with Pivot Charts 🙁 The workaround is to create a regular chart from your PivotTable. I wrote about...

Hi Meyanui, I suspect the reason you haven't had an answer to your question yet is because you haven't been clear in your requirements. You say "I ...

Hi Angela, When your data is laid out in the wrong format, as you already identified, there are often no simple solutions. The formula you're using...

Hi Bill, This thread has an explanation for "Preparing Worksheet": Which is backed up by a similar explanation on this thread: Hope that...

Hi Ciaran, I would watch the video through first. Then practice what you've just learnt using the workbooks to replicate the steps. You may need to...

Hi Amanda, Please watch session 7.01 Parameters Tables for Filtering, and see if you can use that technique for your scenario. Note: since your ...

Hi Shelley, If you're sure that when you add the new button it's not inside the group outline then it sounds like a bug. Are you able to share the ...

Hi Rathanak, You can use the PMT function for a loan schedule: Loans don't usually skip days since the money is still on loan on a weekend and ho...

Hi Vanessa, I suspect the problem lies in the different file formats being merged. Please check that the line containing Csv.Document specifies the...

Hi Jose, In Power Query you can add a custom column and use this formula: =Text.Start( [Hotel], Text.PositionOfAny( [Hotel], {"1","2","3","4","5...

Hi Bill, For future reference you can attach workbooks to the forum post. 1. Click the 'Attachments' button on the bottom left of where you type...

Hi Bernie, Since you weren't clear how you wanted this vertical bar to look I've made some assumptions in the attached file, and below is a link to...