Friday Challenge – Recreate an Excel Project Status Spectrum Chart

SteveEqualsTrue

I am always looking for charts or anything that I can put into an Excel chart. In fact, I just skim the Wall Street Journal articles looking for the pictures (graphs and charts). No really, I get it for the pictures, not the articles

Do you do that too?

Anyway……I recently saw this Project Status Indicator in a PowerPoint presentation and I wondered if we could recreate it in Excel. In PowerPoint is was created by overlaying shapes in the following format:

Do you think you can recreate this Excel Project Status Spectrum?

Here is my representation of the same PowerPoint graph in an Excel Chart:

See if you can create you own Excel Project Status Spectrum.

Here is the sample data set that I used in my Excel chart: Excel-Project-Spectrum-Status-Chart-Data.xlsx

If you are able to do it, leave a comment below and I can send you a personal email where you can send your results. Thanks and Good Luck.

Steve=True

9 COMMENTS

Pete August 8, 2014 At 7:08 am

My solution has been submitted.

- SteveEqualsTrue August 8, 2014 At 10:33 am
  
  Great job. Almost identical to my chart build. Very impressive Pete. Steve=True
  
- William March 9, 2015 At 10:24 am
  
  Pete,
  I am trying to do the same thing in excel, can you forward it to me?
  
  Thanks
  
  - SteveEqualsTrue March 9, 2015 At 10:35 am
    
    Hi William,
    
    Here are the 2 links to the challenge answers. You can download the final sample files at the bottom of the posts:
    
    https://www.exceldashboardtemplates.com/how-to-make-an-excel-project-status-spectrum-chart/
    
    https://www.exceldashboardtemplates.com/new-take-on-the-excel-project-status-spectrum-chart/
    
    Hope this helps!
    
    Steve=True
    
  - Pete March 9, 2015 At 12:18 pm
    
    If the posts that Steve linked to do not answer your questions, let me know, and I will send you a copy of my file.
    
    -Pete
    
Leonid August 8, 2014 At 12:25 pm

Hi Steve,

Yes, I do that too.
Every time I open WSJ I first look through to see what charts they included.
It’s an addiction, but a good one.

I submitted my solution.

- SteveEqualsTrue August 13, 2014 At 4:21 pm
  
  Glad to see I am not too weird.
  
  Great job, looked great. Thanks for your submission. Steve=True
  
If you found the website and tutorials helpful, please consider donating to keep the lights on.

Donate with PayPal here:
sangesh December 22, 2014 At 1:01 pm

Can you send me the solution too

- SteveEqualsTrue January 6, 2015 At 10:02 am
  
  Hi Sangesh,
  
  You can find the solution at this URL:
  https://www.exceldashboardtemplates.com/how-to-make-an-excel-project-status-spectrum-chart/
  
  Also, here is another solution that another user provided:
  
  https://www.exceldashboardtemplates.com/new-take-on-the-excel-project-status-spectrum-chart/
  
  Hope this helps.
  
  Steve=True

Friday Challenge – Recreate an Excel Project Status Spectrum Chart

9 COMMENTS

If you found the website and tutorials helpful, please consider donating to keep the lights on.

Donate with PayPal here:

LEAVE A REPLY Cancel reply

Stay Connected!