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,...
Incredible Excel 2012 Olympic Medal Count Dynamic and Interactive Dashboard
People are awesome and so creative. We have been talking about building an Olympic Medal Count Dashboard using Excel and I asked for your...
Friday Challenge Submissions: Change Chart from Amount to Percent From a Picklist
I received 2 submissions from the Friday challenge. Both were awesome in that they are really creative ways to handle the question from the...
Dashboard Design Examples – Excel Chart X-Axis Grouping
When Designing an Excel Company Dashboard you will want to make sure that your audience can easily read and interpret the data.
Which do you...
Friday Challenge Answer – Dynamic Excel Chart Using Checkboxes for Multi Year by Month...
A big shout out to Pete who submitted this answer to my last Friday Challenge.
You can check out the challenge here:
Friday-challenge-excel-mutli-year-graph-by-month
Check out the video...
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...
How-to Format Chart Axis for Thousands or Millions
Here is a great way to make your Dashboard Charts in Excel more appealing and your boss will love you and your friends will...
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...
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 Make a Dynamic Excel Scroll Bar Chart Part 2
Wow, it has been over 2 years. I am so sorry if you have been waiting all this time. Probably not, but I will finish...