Home Dynamic

# Dynamic

### 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-month Check 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

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

4
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?