Case Study – Mom Needing Help on Science Fair Graphs/Charts
I saw this posting on the ExcelForum site. Please read it, copy it to Excel and give some thought on how you would handle...
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? ...
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...
Problems with an Excel Dashboard Goal Chart
A while ago, a user in an Excel help forum had a chart in his Excel Dashboard that was acting quite strange and he...
Excel VLOOKUP–Left or Right and HLOOKUP Up or Down
Better late than never to the VLOOKUP week as started by Mr. Excel, Bill Jelen.
I have never been a big fan of the Excel...
Case Study Solution – Mom Needing Help on Science Fair Graphs/Charts
Yesterday I presented a case study on assisting a mom in creating a chart for a science fair.
You can read more about it here:
Case...
Think Like a Database Designer Before Creating an Excel Dashboard Chart
Recently, a fan asked for some help. However, when I got their file, I saw that they needed some help with basic concepts, so...
Olympic Medal Count Dashboard
So the summer Olympics start this week. So I thought it would be a good time to visit how one might create an Olympic...
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...
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...