Fastest Way to Open a New Workbook in Excel
I saw in a recent post on Contextures.com, that Excel 2013 has added new option that you can choose to not display the start...
How-To Make a Dynamic Excel Scroll Bar Chart Part 2
Wow, it has been over 2 years. I am so sorry if you have been waiting all this time. Probably not, but I will finish...
3 Ways to Add a Target Line to an Excel Pivot Chart
Add a Target Line to an Excel Pivot Chart
Many Excel users use Pivot Tables and they find it very easy to create a Pivot...
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 a Non-Chart Excel Dashboard Chart (Heat Index)
So I saw this chart in an Excel forum and a user was asking this:
“chart - not sure about this one
I've created a...
Creating Pick Lists in Excel for your Dynamic Dashboard
Creating Pick Lists in Excel
If you want to create a dynamic dashboard in Excel, I am sure you will want to use a picklist...
Friday Challenge – Analyzing Attendance Records with Six Sigma Charts
The following is a guest post from Pete on his answer to the most recent Friday Challenge.
Pete applied his knowledge of Six Sigma to...
How-to Easily Add Task Information to Excel 2016 Gantt Charts
Easily Add Task Information to Excel 2016 Gantt Charts
Excel 2013 and Excel 2016 make this need so much easier. Thanks Excel! I recently posted...
How-to Make a Company Goal Chart or IPAD Battery Chart in Excel
I was looking at my IPod Touch and I really liked the battery graphic that is shown. Then I looked at my IPhone and...
How-to Show Excel Chart Data and Keep Chart Size when Hiding Spreadsheet Columns and...
Many times when you are building your Excel Dashboard Templates, you will want to hide rows or columns in the same area as your...