In our last Friday Challenge, I asked you figure out a way to calculate an average for a non-contiguous (non-adjacent) range that will exclude blanks and zeros. This came from a user questio
This is an awesome guest post from our great friend Pete. He came up with this awesome technique to make a dynamic pie chart without the use of offset. THANKS PETE! Recently I saw some com
In the recent post: Friday Challenge – Mimic Newspaper Chart Line Style in Excel we wondered if it was possible to recreate this Chart Line and Marker Style in Excel. The main issue is that
Facebook Twitter Pinterest WhatsApp Linkedin In a popular post, I showed you how to easily create a Clustered Stacked Column chart in Excel using Multi-Level Category Axis options. Here is w
Last week we presented a chart challenge to see how you represent Food Donation data. Don said that we should keep it simple and sent me a sample chart. Thanks for sending in a solution Don
In a recent issue of USA Today, the following infographic was posted on the U.S. women’s national soccer team player appearances. I liked it and wondered if I could make a similar chart usin
Have you ever created a lot of charts in an Excel Worksheet and drove yourself crazy trying to line the charts up? Notice how the charts above are all not in perfect alignment? Well, here i
A fan of the blog asked a question about this post: Stop Excel From Overlapping the Columns When Moving a Data Series to the Second Axis They wanted to know how to do it with a Pivot Chart i
In are recent post, I showed you how to create a Bullet Chart in Excel. Pete, then sent me another way to create a Bullet Chart in Excel. But the really incredible thing is that you can us
Executives and managers love to see gauge charts in their Excel Dashboards. However, gauge charts may confuse or mislead the dashboard readers. For instance, if you have a gauge range from