A reader, Matt, after reading this post: How-to Format Chart Axis for Thousands or Millions And had the following question: “How do you use this formula without the dollar sign? I am using d
With all the new affordable touch screen computers out there, you may have purchased one. However, if you are like me, you may have large fingers and trouble using your laptop’s touch capab
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
As an Excel dashboard engineer you will often need to create complex calculations for your charts, tables and displays. So today’s challenge is one that was sent in by a reader from another
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 a follow-up to my recent Terrible Chart Tuesday, I wanted to show you 2 different techniques that you can use to create a chart in Excel where the line goes up instead of down when you ha
Hi All, I just got a wonderful Christmas gift from our friend Piotr in Poland. He emailed me his awesome rendering of a Christmas tree in an Excel chart. And I asked if I could share it with
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
Hi All, Here is a fun challenge that I thought you might like. I saw this chart in the Denver Post and I wondered how we could recreate it in Excel. I have posted the data below and I will
Hi All, Sorry my postings have been a little slow. I had several things come up. 1) I got hacked again and had to spend time and money updating the site. I hope you like the new look. 2)
Part of Excel Dashboard design and development should be to know what is right and what is just wrong with a chart or dashboard. So I decided to start another on-going series called “Terrib
Check out what I was seeing out side my back yard window this weekend. Looks like a real life snow globe. Let me know what Country and City (and State/County) you live in – below in the com