How-to Make a Cool Looking 3-D Sales Funnel or 3D Sales Pipeline Chart in...
Some times these types of charts are called funnel charts or some times they are called pipeline charts. Regardless of what you call them,...
How-to Format Chart Axis for Thousands or Millions
Here is a great way to make your Dashboard Charts in Excel more appealing and your boss will love you and your friends will...
How-to Make an Excel Stacked Area Chart Cliff
A while back, I published an article on how to make an Area Cliff Chart.
Now this isn’t a standard chart type.
If you use the Standard...
Advanced Excel Summation Skills Using SUMIFS and SUMPRODUCT
In this post, I will show you 2 other techniques that you can use to evaluate criteria and then create a sum of data...
How-to Easily Hide Zero and Blank Values from an Excel Pie Chart Legend
If you have ever used a Pie Chart in Excel, then you probably ran into this need.
The need to hide Pie Chart Legend entries...
How-To Copy an Excel Chart on Same Worksheet with a New Data Reference
Many users in Excel spend time creating an awesome chart on a specific data set, then they want to use that chart on another...
How-to Make an Excel Single Image Goal Chart
Recently, a healthcare company employee contacted me about a chart he wanted to create. The company that he works for is trying to save...
How-to Make an United States Flag Excel Chart (Happy 4th of July)
Happy July 4th (United States Independence Day).
I am home and not working too much this holiday, but wanted to send out a post on...
Friday Challenge – Create a Percentage (%) and Value Label within 100% Stacked Chart?
First I want to say I am sorry to those waiting to see the dynamic chart scroll bar tutorial. My project launched this week...
How-to Unprotect an Excel Worksheet If You Forgot the Passcode
Several years ago, I created an Excel workbook and I "Protected" a worksheet, but, I forgot the passcode the next day. Try and try,...