Home Tags Dynamic

Tag: Dynamic

Excel Scroll Bar Control

How-To Make a Dynamic Excel Scroll Bar Chart Part 2

Wow, it has been over 2 years.  I am so sorry if you have been waiting all this time.  Probably not, but I will finish...

How-to Easily Make a Dynamic PivotTable Pie Chart for the Top X Values

I recently had a request from a fan of the site on how they could make a dynamic pie chart with the Top 5...

How-to Create a Dynamic Excel Pivot Table Dashboard Chart

In my last 2 posts:I showed you how to setup your data in preparation for creating a dynamic dashboard chartPart 1: think-like-a-database-designer-before-creating-an-excel-dashboard-chartAnd then I...

Friday Challenge Challenge – Excel Chart using Picklist for a Multi Year Graph by...

Hi ExcelDashboardTemplate Fans!Today is a challenge on a challenge.Previously I posted a data set that and asked you to create your own chart of...

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



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