Please bookmark this page and visit often :) -Steve=True

Day

//August 22, 2014
22

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...
Posted On 22 Aug 2014
, By

Help Us Out When You Buy Stuff on Amazon:

Donations Accepted to Help With Site Costs

Help Us Out When You Buy Stuff on Amazon:

Contact Us

  1. Name *
    * Please enter your name
  2. Email *
    * Please enter a valid email address
  3. Message *
    * Please enter message

Donations Accepted to Help With Site Costs

Search Posts by Category

RECENT

POPULAR

COMMENTS

How-to Add Edges to Excel Area Charts

How-to Add Clean Breaks or Cliff Edges to an Excel Area Chart

Posted On 27 Feb 2018

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

Posted On 14 Feb 2018
How-to Add Resource Names to Excel Gantt Chart Tasks

How-to Add Resource Names to Excel Gantt Chart Tasks

Posted On 06 Feb 2018
Quickest Way to Select and Align Charts for an Excel Dashboard Featured Image

Quickest Way to Select and Align Charts for an Excel Dashboard

Posted On 15 Nov 2017
Create Dynamic Excel Chart Conditional Labels and Callouts

Create Dynamic Excel Chart Conditional Labels and Callouts

Posted On 27 Oct 2017
Select Large Range Contiguous

Alternate Ways to Select Large and Non-Contiguous Ranges in Excel

Posted On 03 Oct 2017
Final Stacked and Non Stacked Clustered Column Chart

How-to Create a Stacked and Unstacked Column Chart in Excel

Posted On 19 Sep 2017
Non-Offset Chart Tip

How-to Create a Dynamic Excel Chart of Last 3 Months Data Without Offset

Posted On 10 Jul 2017
Copy an Excel Chart on Same Worksheet Keeps Same Data Reference Final Copied Charts

How-to Copy a Chart and Change the Data Series Range References

Posted On 10 May 2017

Friday Challenge Answer – Find Unique Values from CSV List

Posted On 08 May 2017
Copy Excel Chart on Same Worksheet

How-To Copy an Excel Chart on Same Worksheet with a New Data Reference

Posted On 03 May 2017
AverageIF Across Excel Worksheet Tabs AverageIF Function Result

How-to AverageIF Excluding Zeros Across Excel Worksheet Tabs

Posted On 02 May 2017
Sum Across Excel Worksheets Tabs

How-to Easily Sum Across Excel Worksheet Tabs (Plus Friday Challenge)

Posted On 27 Apr 2017
Better Format for Excel Chart Secondary Axis Columns Overlap with 3 Series

A Better Format For Excel Chart Secondary Axis Columns Overlap with 3 Series

Posted On 23 Apr 2017
Excel Overlapping Columns on Second Axis for 3 Series

Stop Excel Overlapping Columns on Second Axis for 3 Series

Posted On 08 Nov 2016
Calculating Hours Difference of Time in Excel Spreadsheets

Calculating Hours Difference of Time in Excel Spreadsheets

Posted On 03 Nov 2016

How-to Easily Create a Stacked Clustered Column Chart in Excel

Posted On 18 Mar 2013

Stop Excel From Overlapping the Columns When Moving a Data Series to the Second Axis

Posted On 30 Jan 2014

How-to Create and Copy a Table in Google Mail (Gmail) from Excel

Posted On 27 Jun 2013

How-to Make a Sales Pipeline Funnel Excel Chart Template

Posted On 21 Feb 2012

3 Ways to Create Vertical Lines in an Excel Line Chart

Posted On 16 Jul 2012

How-to Make an Excel Project Status Spectrum Chart

Posted On 22 Aug 2014

How-to Make a Beer Mug Goal Chart as an Excel Dashboard Component

Posted On 13 Mar 2013

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

Posted On 10 Feb 2014

How-to Make an Excel Vertical Likert Line Chart with Categories

Posted On 09 Dec 2012

The Best Way to Separate Address Text to Multiple Columns

Posted On 30 Oct 2012
How to Create a Thermometer Goal Chart in Excel

How-to Make a Thermometer Goal Chart in Excel

Posted On 11 Nov 2015

How-to Create a Dynamic Banding on an Excel Line Chart

Posted On 01 Feb 2013

How-to Create a Scroll Bar in Excel to Make Your Dashboard Dynamic

Posted On 30 Jul 2013
Download a Free Target BMI Weight Tracker Spreadsheet

Free Dashboard Template Download - BMI Weight Tracker

Posted On 06 Sep 2011

Dynamically Change Excel Bubble Chart Colors

Posted On 28 Aug 2013

How-to Easily Create a Step Chart in Excel

Posted On 21 May 2014

Hi Jo, it looks like your dates overlap...

Posted On 23 Mar 2018

Thanks Tim. Not sure that it was...

Posted On 23 Mar 2018

Legendary hack solution. Thank...

Posted On 23 Mar 2018

Hi I am trying to have the cell...

Posted On 18 Mar 2018

Hi P. What version of Excel are you...

Posted On 16 Mar 2018

Doesn't work. As soon as I move the...

Posted On 15 Mar 2018

Hi Lai, you could probably change the...

Posted On 05 Mar 2018

Thanks for the nice comment. Glad to help.

Posted On 05 Mar 2018

Thank you, thank you! I have been...

Posted On 02 Mar 2018

Hello Steve=True, I'm so sorry for the...

Posted On 02 Mar 2018

Hi \Lai, not sure how I understand the...

Posted On 02 Mar 2018

Great article, this amazes me! I tried...

Posted On 01 Mar 2018

Hi Dave, can you just add a vertical...

Posted On 01 Mar 2018

This is a great tip. I am looking for...

Posted On 28 Feb 2018

Hi Chuck, i am not quite sure what you...

Posted On 27 Feb 2018

One very simple way to get rid of the...

Posted On 27 Feb 2018
Copywrite 2017 Exceldashboardtemplates.com
If You Enjoyed This Post
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Close
We Know You Better!
Subscribe To Our Newsletter
Be the first to get latest updates and
exclusive content straight to your email inbox.
Yes, I want to receive updates
No Thanks!
close-link
Subscribe Now
SUBSCRIBE

Stay Connected!

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