Add Multiple Percentages Above Column Chart or Stacked Column Chart
I recently posted a tutorial on how you can put a percentage at the top of a Stacked Column Chart. You can see the...
Step-by-Step Tutorial: How-to: Make a Company and Industry P/E (Price to Earnings) Line Chart
In my last post I showed the concepts of making a P/E (Price-to-Earnings) Excel Chart for your Dashboard Template. In this post I will...
Steve Williams Caddie Earnings After Tiger Woods Split – Mini Dashboard
Now, you may know that I am a PGA Tour Golf fan and you may also know that Tiger Woods has been doing very...
Excel Super Bowl Statistics Dashboard
A great big shout out to Don who submitted the best Excel Dashboard of Super Bowl Statistics.
It has a neat design and uses picture...
How-to Format Trend Line Color in Excel Dynamically
Many users use Trend Lines in Excel charts and graphs. They may also be used in Company Dashboards, but to you can make your...
Where Did My Excel 2013 Pyramid Charts Go? (Or How-to Make a Sales Pipeline...
In a previous post I showed you how to make an Excel Sales Funnel Chart or Sales Pipeline Chart, but it is a little...
How-to Show Decades and Highlight a Year in the Horizontal Axis
Recently in an Excel Forum, a user had data similar to this format:
Here is what he wanted to do:
How do I set the Horizontal...
Case Study – Creating a Dynamic Chart in Excel Using Offset Formula
A YouTube video subscriber Mili, wanted to know more about creating a Dynamic Excel Column Chart using Offset function. So Mili sent me the...
How-to Create a Dynamic Excel Chart of Last 3 Months Data Without Offset
Chart of Last 3 Months
If you wanted to create a dynamic Excel chart of last 3 months of your data but didn't know how to...
2008-2012 Summer Olympics Medal Count Dashboard Part 2
Wow, what a Summer Olympics. the 2012 medal count is so close. China and the USA are neck and neck in terms of total...