Quantcast

New Take on the Excel Project Status Spectrum Chart

Leonid, a wonderful reader of our website, sent in a new take on my Excel Project Status Spectrum Chart.  Here is what his looks...

How-to Easily Add Task Information to Excel 2016 Gantt Charts

Easily Add Task Information to Excel 2016 Gantt Charts Excel 2013 and Excel 2016 make this need so much easier. Thanks Excel! I recently posted...

Pipeline Challenge Matching Stacked Bar Chart Colors to Products without VBA

In our recent Friday Challenge, we were tasked with creating a Stacked Bar Chart where the colors matched the products.  You can check out...
Fix Error Current Sales Greater than Sales Goal - Thermometer Chart in Excel

How-to Fix Sales Goal Error of Excel Thermometer Chart

How-to Fix Sales Goal Error of Excel Thermometer Chart I have to admit that I messed up and presented a broken solution for the Excel...

How-to Fix Security Links Warnings in an Excel Spreadsheet

If you have the yellow bar show up at the top of your Excel Spreadsheet "! Security Warning - Automatic update of links has...

How-to Add a Line to an Excel Chart Data Table and Not to the...

8
Many people making Excel charts love to add a Chart Data Table to their graph.  However, the Excel Data Tables are not very flexible...

Removing Gaps in an Excel Clustered Column or Bar Chart (Part 2)

Removing Gaps - Excel Clustered Column or Bar Chart (Part 2) In an earlier Friday Challenge, I posted a problem where someone wanted to remove...

How-To Create an Excel Step Chart Formula Using the Small Function

In our last Friday Challenge, we were investigating Step Charts.  In case you missed it, you can check it out and download the sample...
Single Image Tree Goal Chart

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...

Friday Challenge Answer – Create a Percentage (%) and Value Label within 100% Stacked...

14
Last week I posted a Friday Excel Challenge!.  Fun times.  How did you do?  Spoiler alert, if you don’t know how to create this...
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