How-to Create Dynamic Excel Dashboards Using Picklists
This is a great technique that you can use to create dynamic charts that will change when your users change the values from the...
Create a Dynamic Excel Pie Chart
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...
Dashboard Design Examples – Excel Chart X-Axis Grouping
When Designing an Excel Company Dashboard you will want to make sure that your audience can easily read and interpret the data.
Which do you...
Creating Pick Lists in Excel for your Dynamic Dashboard
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 is the Bomb: or How I came to love the Offset function
Wouldn’t that be awesome if Excel can just change my chart every month or week when I add more data? This can happen for...
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...
How-to Make a Dynamic Chart Using Offset Formula
In previous posts I have described how to make a Dynamic Chart in Excel for your Dashboard using Tables. This is a very easy...
How-to Make a Dynamic Excel Pie Chart with 4 steps in less than 4...
This is an awesome guest post from our great friend Pete. He came up with this awesome technique to make a dynamic pie chart...
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? ...
How-to Create a Dynamic Banding on an Excel Line Chart
This dynamic shading or banding chart is frequently used in science and in Company Dashboards. It allows the user to quickly see if their...