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

3
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-month Check out the video...

Friday Challenge Answer – Using Excel Slicers to Create Dynamic Charts

1
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

5
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

0
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

12
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

6
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

2
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

3
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

2
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

4
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