How to make a Dashboard Template for a P/E Price-to-Earnings Excel Chart

Company and Industry P/E (Price to Earnings) Line Chart – 2 Ways

2
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,...
Practice Excel Helps Learning

Practice Makes Perfect Excel Dashboards and Charts

2
I would strongly recommend that if you want to get better at building Excel Dashboard Charts and Graphs that you should try and recreate...

Using the Camera Tool to Create a Vertical Line Chart in Excel

1
Last week a user in the Mr. Excel Forum wanted to know how to make a vertical line chart where the horizontal categories are...

How-to Make a Wall Street Journal (WSJ) Double Lollipop Chart in Excel

In our last Friday Challenge, I proposed making a Double Lollipop Chart seen in the Wall Street Journal (WSJ).   Here is what our final chart...
Excel Legend Tips and Tricks

Tips and Tricks – Longer Legend Color Bars in Excel Charts

7
Here is a real quick tip that you may want to learn when using Excel.  This tutorial will help you apply this technique to...

New Chart Label Leader Lines Available in Excel 2013

Did you know that you can now add Leader Lines to your Excel Charts in Excel 2013?  I didn't know this until just recently. ...

How-to Eliminate Statistical Outliers in an Excel Line Chart

4
Okay, I posted this Excel Chart Challenge on Friday.  How did you do?  I am sure your solution is better than mine.  This was...

Grouping Excel Column Charts with a Box

0
In a previous post, I showed you how to group a column chart with lines: You can check out the posting here: Group Column Chart...

How-to Create Sales Quota Threshold Horizontal Lines in an Excel Column Chart

6
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...
Download a Free Target BMI Weight Tracker Spreadsheet

Free Dashboard Template Download – BMI Weight Tracker

13
In this ever expanding universe, so is my belt.  I need to drop more than a few pounds. Now I can use an Excel Dashboard...