Tag: Excel Chart
Zombie Pie Chart in Excel – What would you do?
The Walking Dead has been an amazing hit as a new show and is now finishing up its second season. Unfortunately, I am out...
Dashboards are Everywhere!
Dashboards Can Be Found Everywhere
I am presently in Suzhou China working on a new project and I decided to go to the gymnasium. I...
Date and Time Series Issues in Excel Charts
Many users think they are getting an axis error when they say that their column or line charts are showing every date between data...
How-to Copy Charts and Change References to New Worksheet
Have you ever made a great chart for your Excel Dashboard and you wanted to reuse it for another set of data? Perhaps you...
How-to Hide a Zero Pie Chart Slice or Stacked Column Chart Section
Okay, we have learned lots of different techniques to build our Company Executive Dashboard using Excel, and today I will give you a taste...
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...
This is the Bomb: or How I came to love the Offset function
Wouldn’t that be awesome if Excel can just change my chart every month or week when I add more data? This can happen for...
How-to Make Dynamic Excel Dashboard Charts Using Tables
For almost every Excel Dashboard you will want to make a Chart template Dynamic. Meaning that as you add new data, the chart updates...
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...
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...
