How-to Connect Gaps in a Line Chart in Excel
When you are build your Excel Dashboard Template charts, you may find that some of your data is not complete. For instance, you may...
How-to Fix Security Links Warnings in an Excel Spreadsheet
If you have the yellow bar show up at the top of your Excel Spreadsheet "! Security Warning - Automatic update of links has...
How-to Use Data Labels from a Range in an Excel Chart
Excel 2013 has some cool features. If you were not aware, here is an awesome Chart Data Label option that you now have when...
How-to Show an Apostrophe at the Beginning of a Text String in Excel
I saw that an Excel user was having a problem when creating his VBA code and you may run into this problem when you...
How-to Copy a Chart and Change the Data Series Range References
Last week we learned how to copy a chart in Excel quickly and have it reference a new chart data range on the same...
Advanced Excel Summation Skills – Using ARRAY Formulas to Check for Multiple Criteria
In this post, I will show you another Excel summation technique that you can use to evaluate criteria and then sum the data based on that...
How would you chart this in Excel for your executive dashboard?
An Excel forum user posted the following question. I wanted to see how my readers would answer the following question. Tomorrow I will post...
How-to Create a Dynamic Excel Chart of Last 3 Months Data Without Offset
Chart of Last 3 Months
If you wanted to create a dynamic Excel chart of last 3 months of your data but didn't know how to...
Change Chart from Amount to Percent using a Drop Down List
In case you were wondering, here is my solution to last Friday’s Excel Challenge.
Our challenge was to see if we could solve this question...
Problems with an Excel Dashboard Goal Chart
A while ago, a user in an Excel help forum had a chart in his Excel Dashboard that was acting quite strange and he...
