Protecting Your Excel Charts and Dashboards with Array Formulas
Has this ever happened to you?
You have sent your Excel Dashboard to your executive team or perhaps you have your spreadsheet on a shared...
Halloween Special – Spider Web, Spider and the Fly Chart
In honor of Halloween I thought I would post something fun. For those that are not in the USA, Halloween is where children dress...
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 Make a Pass Fail Chart in Excel
Last week, I posed a Friday Challenge that was posted in a Q&A for Excel. Here it is:
*****************************************************************
Plotting a line graph to track build...
How-to Create a Scroll Bar in Excel to Make Your Dashboard Dynamic
This is part 1 of creating a dynamic Excel dashboard chart using the scroll bar control.
So in the title I said that we would...
The Easiest Way to Copy An Excel Worksheet – (With Only One Click)
Frequently when working in Excel, I will need to copy an entire worksheet.
Copying an entire worksheet is particularly helpful when you are need to...