Tag: Dynamic Chart

Chart of Last 3 Months If you wanted to create a dynamic Excel chart of last 3 months of your data but didn't know how to...

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

In my last post, Think-like-a-database-designer-before-creating-an-excel-dashboard-chart we described the best way to configure your data to easily create your next dashboard. In this post, we explore the...

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

Have you ever wanted to create a graph but then let users dynamically change the Excel chart type with a drop down pick list? ...

This is a great technique that you can use to create dynamic charts that will change when your users change the values from the...

Creating Pick Lists in Excel If you want to create a dynamic dashboard in Excel, I am sure you will want to use a picklist...

This dynamic shading or banding chart is frequently used in science and in Company Dashboards.  It allows the user to quickly see if their...

How-to Create a Dynamic Excel Pie Chart Using the Offset Function Recently, I viewed a forum post where a user wanted to create a dynamic...

A YouTube video subscriber Mili, wanted to know more about creating a Dynamic Excel Column Chart using Offset function.  So Mili sent me the...