Chart
3 Ways to Add a Target Line to an Excel Pivot Chart
Check out this post to LEARN 3 Different Ways That you Can Add a Target Line / Goal Line to Microsoft Excel Pivot Chart for you Executive Dashboard.
EXPLORE THE LIBRARY
Dashboard
Chart
How-to Add Specific RGB or HSL Colors in Your Company Chart or Dashboard
Do you want your Excel charts and dashboards to really stand out at your company? Well then you should start using custom colors in all your graphs. It is really simple, but some people do n
Chart
How-to Create a Dynamic Excel Pivot Table Dashboard Chart
In my last 2 posts: I showed you how to setup your data in preparation for creating a dynamic dashboard chart Part 1: think-like-a-database-designer-before-creating-an-excel-dashboard-chart
Chart
Think Like a Database Designer Before Creating an Excel Dashboard Chart
Recently, a fan asked for some help. However, when I got their file, I saw that they needed some help with basic concepts, so I thought I would share those concepts with you. Now, let me pr
Excel tutorial
Friday Challenge Answers – The Boss Says…
I received some great responses from lots of fans. Thank you so much for all your great comments. I agree with most and my solution was very similar to Peter R.’s below. BUT, as always, P
Combined Chart
Friday Challenge Answers – Food Donation Excel Dashboard Chart
Last week we presented a chart challenge to see how you represent Food Donation data. Don said that we should keep it simple and sent me a sample chart. Thanks for sending in a solution Don
Challenge
Friday Challenge – How Would You Chart It?
Today the ExcelDashboardTemplate.com Friday Challenge is up to you and your wildest imagination. An Excel chart newbie posted this data set and wasn’t sure the best way to represent the data
Align
How-to Line Up Your Excel Worksheet Embedded Charts
Have you ever created a lot of charts in an Excel Worksheet and drove yourself crazy trying to line the charts up? Notice how the charts above are all not in perfect alignment? Well, here i
Dashboard
Where Did My Excel 2013 Pyramid Charts Go? (Or How-to Make a Sales Pipeline Chart in Excel 2013)
Where Did My Excel 2013 Pyramid Charts Go? (Or How-to Make a Sales Pipeline Chart in Excel 2013)
Challenge
Friday Challenge – Analyzing Attendance Records with Charts and Trend Line
For this Friday Challenge, lets see if we can help this user with their data. Read it over, but really, the last line of the request is my favorite “other ways”. This can be with one chart