If you have a chart with Legends, then you should check out this tutorial. Recently when working on a solution for a fan, I noticed that it was not clear on my Stacked Column Chart which ser
Several years ago, I created an Excel workbook and I “Protected” a worksheet, but, I forgot the passcode the next day. Try and try, I couldn’t remember the password. Therefore, I could nev
In the last Friday Challenge, I presented you with 17,000+ data points representing 2 days of network data usage. With so many data points, it may be best to visualize the data to see what i
Today I answer a viewer question. “How do I add a cumulative grand total amount as a line above a stacked column pivot chart in Excel?” Well there are a few tips and tricks to create this t
Facebook Twitter Pinterest WhatsApp Linkedin Have you ever tried to draw a straight line in Excel only to get frustrated? It can be so Frustrating 🙂 to be off by one or 2 pixels. Well Excel
We should have some fun as it is the start of a long weekend and the end of summer. So what better way to have fun than with some pranks. And better yet, Excel Pranks. I saw a great thread
In my last 2 posts: I showed you how to setup your data in preparation for creating a dynamic dashboard chart Part 1: think-like-a-database-designer-before-creating-an-excel-dashboard-chart
As Excel users, we may create a spreadsheet with many many many worksheets (tabs at the bottom) within the workbook. However, if you create more tabs than you can see on the bottom of the s
In our recent Friday challenge, we were asked by Anna how can we make our popular Excel Step Chart work for data that is not date based, but time based. The use case is a medical study on s
In our recent Friday Challenge, we were tasked with creating a Stacked Bar Chart where the colors matched the products. You can check out the challenge here: Original Challenge: friday-chal