For today I have a quick tip on creating a specific labelling for bar charts. This has come out of Workout Wednesday 2021 Week 44. Usually, labels are either at the end of the bar chart (automatic / right), at the end but inside the bar (left) or inside centered (center alignment). But what if … Continue reading A Quickie on bar chart labelling
When speaking about table calculations a repeated request is to show ranking over time based on for example cumulative sales. Usually, the question will be why what the asker is doing does not work as intended. Lets have a look at the most common reason.
One thing that you may have stumbled upon is when you are trying to swap a sheet that is text only. In this case, the text only sheet will not entirely collapse. Let's quickly dive into how to solve that.