How-to Show Excel Chart Data and Keep Chart Size when Hiding Spreadsheet Columns and...
Many times when you are building your Excel Dashboard Templates, you will want to hide rows or columns in the same area as your...
How-to Make an Excel Project Status Spectrum Chart
Here is the long awaited demonstration of a recent Friday Challenge.
The challenge was to recreate a Project Management Status Chart that I saw on...
How-to Make a Dynamic Hotel Ballroom Occupancy Chart
In a previous Friday’s challenge, I presented the following user request.
Here was the question again and what you would have seen in the download...
3 Ways to Make Excel Chart Horizontal Categories Fit Better
Have you ever had a chart where your Horizontal Category Labels overlap each other and they are unreadable?
Check out this chart to see what...
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,...
Replace Numbers with Text in Excel Radar Chart Axis Values
Replace Numbers with Text in Excel Radar Chart Axis Values
This is a cool Excel Trick that I just created based on a user request...
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 Create a Dynamic Banding on an Excel Line Chart
This dynamic shading or banding chart is frequently used in science and in Company Dashboards. It allows the user to quickly see if their...
Where Did My Excel 2013 Pyramid Charts Go? (Or How-to Make a Sales Pipeline...
In a previous post I showed you how to make an Excel Sales Funnel Chart or Sales Pipeline Chart, but it is a little...
Create Dynamic Excel Chart Conditional Labels and Callouts
Chart Conditional Labels and Callouts
Learn how to make the simple and easy these Excel Chart Label Callouts:
In my most recent article, I described how...