Home Tags Excel Graph

Tag: Excel Graph

How-to Show Gaps in a Line Chart When Using the Excel NA() Function

In last Friday’s challenge, we had a Excel Analyst that needed to remove outliers from his Excel Line Chart.  In essence, he wanted to...

How-to Put Percentage Labels on Top of a Stacked Column Chart

There are times when you are creating your Excel Dashboard Design that you desire something that does not come naturally with the Excel Tools...
Limitations for Excel Charts

Charting Specifications and Limits for Excel 2003, 2007 and 2010

Have you ever wondered how many data series you can actually add to an Excel chart?  Well there are limits.  Recently an Excel Client...

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

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 Make a Dynamic Chart Using Offset Formula

In previous posts I have described how to make a Dynamic Chart in Excel for your Dashboard using Tables.  This is a very easy...

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

Popular Posts

How-to Easily Create a Stacked Clustered Column Chart in Excel

Create a Stacked Clustered Column Chart in Excel There is one type of chart that is always requested, however, Excel doesn’t offer this type 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