everydayExcel Newsletter Header

Breakthroughs in Dashboard Speedometer

We can't wait to share this with you. There have been exciting improvements made to our speedometer chart which was first revealed in our "Interactive Dashboard Reporting with Excel" course. Previously we were able to create a speedometer chart (without the use of macros) that helps to visualize spending against budget, with the percentage changing automatically as the selected month changes. It looked like this:

speedometer_old

Although it achieved what we had intended, we felt that it could be further improved with an additional scale to make it more like a car speedometer. However, then we were not able to do it without the use of macros, which we did not want to introduce into this course. When no other solution could be sourced from the web, we decided to venture into areas that have not been explored by other Excel experts and tried to experiment with the various features we could lay our hands on. In this issue of our newsletter, we are glad to announce that we have got a breakthrough. The following speedometer is finally created, without any use of macros.

speedometer_new

So if you are coming for the next Interactive Dashboard Course, you can expect to create this better and more professional looking speedometer. For those who have attended the course before, you don't have to attend the course again. We will record the steps to do this in our next course and share it with you on our membership portal www.excel-course.com.


Ask us an Excel question and get your question answered by our team of Excel experts

Question: Looping in Macro for replacing a few values

i would like to replace MAL as Malaysia / IND as Indonesia / CAM as Cambodia. Is there a way to loop and use IF condition? .... 

Click on this link to read the full question and answer.


Upcoming Courses

With the newly introduced PIC bonus, you are now paid (not paying) 60% of the course fees for sending your staff to our courses. Check out now in this IRAS PIC Link.

Hidden Secrets in Data Analysis with Excel 2007/2010 - 16 & 17 Sep 2013 

Interactive Dashboard Reporting with Excel 2007/2010 - 17 & 18 Oct 2013 

Learning the Magic of Macros 2007 (Excel VBA) - 7 & 8 Nov 2013 

Breakthrough Performance for HR in Excel 2007/2010 - 29 & 30 Aug 2013 

Dynamic Real-Time Forecasting with Excel 2007/2010 - 5 & 6 Sep 2013

For the details of the courses, please refer to our Excel courses page.


Subscribe to our newsletter

If you received this newsletter from a friend and would like to be included in our mailing list, please go to our Excel Today's page.


Follow us at Facebook, LinkedIn

If you have a facebook account, you can like us at facebook or linkedln. From facebook or LinkedIn, you will be notified on mini cases and ideas how we use Excel on a day to day basis. These tips may not be published in our newsletter.


Yours Sincerely,

Jason Khoo
Chief Trainer
everydayExcel Business Lab Pte Ltd
Author of "Hidden Secrets of Data Analysis with Excel" and 
"Excel Secrets for Highly Effective Marketers"

 

Received this newsletter from a friend? You can request to be included in our mailing list by signing up at our Excel Today's page. If you have friends whom you think might be interested in this newsletter, feel free to send it to them.