Practice Makes Perfect Excel Dashboards and Charts
I would strongly recommend that if you want to get better at building Excel Dashboard Charts and Graphs that you should try and recreate...
How-to Draw a Vertical and Horizontal Line that Intersect in an Excel Chart
Recently a user in the Mr. Excel Forum a member wanted to know how they could make an Excel Chart where one Metric was...
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...
Tips and Tricks – Longer Legend Color Bars in Excel Charts
Here is a real quick tip that you may want to learn when using Excel. This tutorial will help you apply this technique to...
Group Column Chart with Lines for Excel Dashboard Presentations
Yesterday a user in the MrExcel.com Forums asked how he could make a Column Chart in Excel and then Group those Columns with a...
Terrible Chart Follow-up
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...
Company and Industry P/E (Price to Earnings) Line Chart – 2 Ways
Here is a fun and easy Dynamic Excel Chart that you can use in your Excel Dashboard Template.
This Excel Chart has many financial research,...
How-to Create a Combo Line and Column Pivot Chart
Some Excel users can be confused when it comes to Pivot Tables and Pivot Charts. I recently saw a post asking for this help:
"Please...
How-to Add Lines in an Excel Clustered Stacked Column Chart
I have posted several Excel chart samples related to Clustered Stacked Column Charts.
In case you missed them, you can check them out here: Excel...
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...
