Archive for May, 2017
Here is a simple but vital charting rule.
Start your bar (or column) charts from zero.
To illustrate why you should do this, let me share a personal example.
Over the weekend, the Jon Peltier visited Wellington. He is staying with Jeff (who occasionally guest blogs on Chandoo.org). On Sunday, we all decided to hike up a small mountain near my house for a leisurely family picnic.
While on the top of the mountain, Jo (my wife) took a few pics of us three Excel geeks. As we were standing on a sloping mountain face this is how the pictures look.
Looking at the picture on left, you would confidently say that I am way shorter than other two. But picture on right tells a different story.Continue »
Recently I was creating a pivot report with multiple items in row labels area. I had to show sub-totals, but only for one of the fields. Something like above.
How to show selective sub-totals in Pivot TablesContinue »