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
My solution has been submitted.
Great job. Almost identical to my chart build. Very impressive Pete. Steve=True
Pete,
I am trying to do the same thing in excel, can you forward it to me?
Thanks
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
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
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.
Glad to see I am not too weird.
Great job, looked great. Thanks for your submission. Steve=True
Can you send me the solution too
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