Protecting Your Excel Charts and Dashboards with Array Formulas
Has this ever happened to you?
You have sent your Excel Dashboard to your executive team or perhaps you have your spreadsheet on a shared...
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...
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...
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...
USA Today Charts Part 2 – Excel Area Chart with Line and Area Highlights
Well, I have been working hard on my project and it has successfully launched. But that took time away from my other passion, EXCEL!!!
So...
How-to Create a Dynamic Excel Chart that Only Displays Non-Blank Values
Below is a video that may help you as well.
How-to make a Dynamic Excel chart that doesn't show blank values so you don't have to...
How-to Make a USA Today Pie Chart Graph – Replicating All Charts in USA...
I have been traveling very frequently for business as a Salesforce.com Software Consultant, so I spend a lot of time in hotel’s and airports. ...
How-to Make an Excel Death Star Pie Chart
While fooling around with Excel, I wondered if I could make an Excel chart look like a the Star Wars Death Star. Well, I...
Steve Williams Caddie Earnings After Tiger Woods Split – Mini Dashboard
Now, you may know that I am a PGA Tour Golf fan and you may also know that Tiger Woods has been doing very...
How-to Easily Create a Stacked Clustered Column Chart in Excel
Create a Stacked Clustered Column Chart in Excel
There is one type of chart that is always requested, however, Excel doesn’t offer this type of...