Tag: How-to
How-to Add Label Leader Lines to an Excel Pie Chart
This a an awesome technique to make your pie charts stand out in your Excel dashboard. However, I didn’t know about it for 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...
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...
How-to Make a Beer Mug Goal Chart as an Excel Dashboard Component
Time for some beer and Excel. Last month I saw that a User was wondering how to make Beer Mug Goal Chart for their...
How-to Make a Weekly 24 Hour Time Worked Gantt Chart in Excel
I have seen many questions where an Excel users want to know more about how to create a Gantt Chart using Time instead of...
