Now I know that not everyone is going to want to do this, but one of the things that I find which really helps me understand complex calculations or visuals, is to manually replicate the values used. It helps me
Introduction I’m a big fan of building Box and Whisker plots (also known as Box plots to those in the statistics world) to interpret certain data sets. While I tend to use these for charting Power Query refresh times, they
Introduction I’m a big fan of Excel's Box and Whisker chart (also known as Box plots to those in the statistics world). While they can be used in a variety of applications, my personal use case is to try and
Some of the really cool charts that we can build in Excel involve the trick of combining multiple chart types together to make them happen. In this article, we’ll build one of those; a temperature chart that not only shows
Something that can be very handy when you’re building a dashboard is to return a certain picture depending on a condition. We can use VLOOKUP to look up data in a table and return the corresponding value from a different
Since I know I have a few charting guys that follow this, I figured that I'd ask this question here. Hopefully the response will help someone! I'm creating a food & beverage function evaluation form, and threw a chart on
I came across this a while ago in a weather app on my iPhone, and thought it was interesting. Then there was a conversation on Twitter in which I brought it up as well. I'm not a huge fan of
I had an email exchange with Charley Kyd tonight, and I was bemoaning the fact that I couldn't link my Excel chart titles to a range. I could have sworn you could do this, but not working with charts a
In a blog post last week, I was looking at the image formats to use when I snapped a picture of a chart. I'm kind of glad that Jon agreed with my assessment on EMF being the best image format
*Note:* The charts in this post are based on sample data and do not reflect any real financial performance. In setting up my first dashboard, I took a page out of Charley Kyd's book and placed a bunch of little
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
