How-to Make an Excel Chart Title Change Dynamically
Have you ever wanted to change your chart title dynamically?
Perhaps you wanted to link it to a cell value?
Did you know that it...
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...
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 Add Custom Labels that Dynamically Change in Excel Charts
Have you ever wanted to have a different data point label in your Excel Chart than what is offered by the Standard Excel Dialog...
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...
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...
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 – 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...
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...
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 chart
Part 1: think-like-a-database-designer-before-creating-an-excel-dashboard-chart
And then I...
