Quantcast

How-to Show Excel Chart Data and Keep Chart Size when Hiding Spreadsheet Columns and...

0
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...
Overlapped Horizontal Categories

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 for Excel Radar Chart Axis Values

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

16
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

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...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link