Tag: Dashboard Chart
How-to Make an Excel Single Image Goal Chart
Recently, a healthcare company employee contacted me about a chart he wanted to create. The company that he works for is trying to save...
How-to Create a Dynamic Excel Pivot Table Dashboard Chart
In my last 2 posts:
I showed you how to setup your data in preparation for creating a dynamic dashboard chart
Part 1: think-like-a-database-designer-before-creating-an-excel-dashboard-chart
And then I...
How-to Make an Excel Clustered Stacked Column Chart with Different Colors by Stack
In a popular post, I showed you how to easily create a Clustered Stacked Column chart in Excel using Multi-Level Category Axis options.
Here is...
How-to Make a Tenant Timeline Excel Dashboard Chart
So last week, I posted this question that I responded to in an Excel forum. I also asked you how you would solve this...
How-to Create a Sick Leave Excel Dashboard Chart
Okay, I got an email from a SUPER FAN of my sight. She even donated some money to help cover the costs of that...
Protecting Your Excel Charts and Dashboards with Array Formulas
Has this ever happened to you?
You have sent your Excel Dashboard to your executive team or perhaps you have your spreadsheet on a shared...
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 Create Sales Quota Threshold Horizontal Lines in an Excel Column Chart
Sales executives are always pushing their sales teams. They typically do this by setting sales quota’s for their salespeople. Quotas are thresholds or minimum...
Case Study: Executive Dashboard Chart Creation – Follow-up
The Problem
In a recent post:
“Case Study: Executive Dashboard Chart Creation” (https://www.exceldashboardtemplates.com/?p=1612)
I presented some basic data that you may have in your company that you...
Make a Pie Chart Rating for Excel Dashboard Chart Templates
In a recent forum post, a dashboard user was asking how they can turn a decimal like 1.5 out of a 3.0 possible into...
