Excel Dashboard Template Step-by-Step Tutorial and Sample File

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...

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...
Chart of Tiger Woods Victories on PGA Tour and in Majors

Tiger Woods PGA Tour and Major Championship Chart

I am a fan of the PGA and Tiger Woods.  So I was really excited when I saw this post from Paresh Shah of...

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 Show Decades and Highlight a Year in the Horizontal Axis

Recently in an Excel Forum, a user had data similar to this format: Here is what he wanted to do:   How do I set the Horizontal...



Final Stacked Column Pivot Chart with a Grand Total Line

How-to Add a Grand Total Line on an Excel Stacked Column Pivot Chart

Today I answer a viewer question. "How do I add a cumulative grand total amount as a line above a stacked column pivot chart...

Dashboard Chart of Tiger Wood’s Money Ranking List and Golf Earnings

With the upcoming Open Championship (also known as the British Open) in Royal Lytham & St. Annes Golf Club, I wanted to see how...

Sample Displays of Excel Chart Dashboard Designs using Axis Groupings

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 – Analyzing Attendance Records with Six Sigma Charts

The following is a guest post from Pete on his answer to the most recent Friday Challenge. Pete applied his knowledge of Six Sigma to...



Friday Challenge Answers – Cumulative Events Over Time

In our recent Friday Challenge, Friday Challenge – Creating an Excel Graph of Cumulative Events Over Time where a user wanted the following:   Creating a graph of...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link