How-to Make a Beer Mug Goal Chart as an Excel Dashboard Component
Time for some beer and Excel. Last month I saw that a User was wondering how to make Beer Mug Goal Chart for their...
How-to Add a Line to an Excel Chart Data Table and Not to the...
Many people making Excel charts love to add a Chart Data Table to their graph. However, the Excel Data Tables are not very flexible...
Excel Line Charts Using a Date Axis
Not sure if you knew this or not, but Excel is amazing!
The makers of Microsoft Excel even went so far as to make sure...
How-to Create an Excel Dashboard Column Chart with 2 Axis Groupings
Recently I saw this in the MrExcel Forums. The title “Weird Charts with 3 Axis” intrigued me.
I determined that they were looking to put...
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...
How-to Make Longer Legend Color Bars in an Excel Chart Video Tutorial
Most Excel 2D Column Charts have small color boxes in the legend to point you to the right series in the graph. However, this...
Create a Dynamic Excel Pie Chart
How-to Create a Dynamic Excel Pie Chart Using the Offset Function
Recently, I viewed a forum post where a user wanted to create a dynamic...
Why Does Excel Switch Rows/Columns in My Chart?
Excel can do some crazy things to your Dashboard Templates, Charts and Graphs, but most of the time we just roll with the punches. ...
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...
Merry Christmas from Excel Dashboard Templates
Hope you and your family and friends have a wonderful Christmas season.
For the season, I have created a Christmas Wreath made from an Excel...
