Quantcast

Protecting Your Excel Charts and Dashboards with Array Formulas

2
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

0
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

4
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

16
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)

1
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...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link