Friday Challenge Answer – Dynamic Excel Chart Using Checkboxes for Multi Year by Month...

A big shout out to Pete who submitted this answer to my last Friday Challenge.You can check out the challenge here:Friday-challenge-excel-mutli-year-graph-by-monthCheck out the video...

Friday Challenge Answer – Using Excel Slicers to Create Dynamic Charts

A big thanks to Don for submitting the first response to last week’s Friday Challenge. You can check out the challenge here: Friday Challenge – Excel...

Excel Super Bowl Statistics Dashboard

A great big shout out to Don who submitted the best Excel Dashboard of Super Bowl Statistics.   It has a neat design and uses picture...

Show or Hide Selected Chart Data Points in Excel with VBA

Okay, for the last challenge, Peter went above and beyond and also submitted a VBA solution to this problem.  Great job Peter!Here is how...

Show Only Selected Data Points in an Excel Chart

So last week I posted this question in the challenge:Here the user story on what we are trying to do:‘As an Excel user I...



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...

Friday Challenge Submissions: Change Chart from Amount to Percent From a Picklist

I received 2 submissions from the Friday challenge.  Both were awesome in that they are really creative ways to handle the question from the...

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 Eliminate Statistical Outliers in an Excel Line Chart

Okay, I posted this Excel Chart Challenge on Friday.  How did you do?  I am sure your solution is better than mine.  This was...



How-to Make a Picklist Change the Chart Type for a Dynamic Excel Dashboard

Have you ever wanted to create a graph but then let users dynamically change the Excel chart type with a drop down pick list? ...
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