Excel Dashboard Templates

For this Friday's challenge, lets see how we can help this user visualize this data set.  Here was the Excel user's question:   "Mutli-year graph by month" I need to make a graph that charts data by...

Some times these types of charts are called funnel charts or some times they are called pipeline charts.  Regardless of what you call them, Excel doesn’t have a native chart type.  But don’t fear,...

Here is a quick demonstration on the technique that Peter used for his Step Charts: Learn More about the Challenge HERE   To try it yourself as you watch the video, download this file and copy the...

In our last Friday Challenge, we were investigating Step Charts.  In case you missed it, you can check it out and download the sample data file here:  Friday Step Chart Challenge   Also, you should check out...

Here is the first and easiest answer to the challenge on posted on Friday. In case you missed it, you can check it out and download the sample data file here:  Friday Step Chart Challenge   So far,...

Yesterday, I posted the a demonstration on how to make a Step Chart in Excel. You can check out that post here: How-to Easily Create a Step Chart in Excel However, the process of setting up the...

You might be asking yourself, “What is a Step Chart?” You have probably seen one, but didn’t know that it is called a step chart. Here is what one looks like:   Why use a step chart? Step charts...

In a previous post I showed you how to make an Excel Sales Funnel Chart or Sales Pipeline Chart, but it is a little trickier to create this graph in Excel 2013. You can read...

I have just started on a new project and I ran across this error or should I say issue?  Maybe you have seen this before, but if not, check out this quick post and...

So that everyone can use my Excel Charts and Dashboard Templates, I typically save my files in an Excel 97-2003 format.  There are other good benefits of this file type, but we can talk...