I recently had a request from a fan of the site on how they could make a dynamic pie chart with the Top 5 values. The user had to create this pie chart regularly from a larger data set and
A few days ago, I had a user ask me a question on the blog about how she can display military time in Excel. It is pretty simple to display in Excel but only if you know how Excel treats tim
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
In my last post, Think-like-a-database-designer-before-creating-an-excel-dashboard-chart we described the best way to configure your data to easily create your next dashboard. In this post,
Recently, a fan asked for some help. However, when I got their file, I saw that they needed some help with basic concepts, so I thought I would share those concepts with you. Now, let me pr
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 the last Friday Challenge, we were going to see if we could help a user create a chart from this data set. They were confused on what type of chart to make and how to do it. To the user
In the recent Friday Challenge: Create Pipeline Usage Chart A user wanted to create a bar chart where the values had a specific color by product and also matched represented the size of the
Facebook Twitter Pinterest WhatsApp Linkedin In this recent post: Friday Challenge Answers – Cumulative Events Over Time I created a formula that referenced a table. As I created my video I