Friday Challenge – Showing More Categories in an Excel Chart

Can you help Kevin with his problem?

Kevin saw this article:

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


“Hi Steve,

Issue at hand: I am an engineer who wants to properly graph and show my boss how much time I am

designing/modeling 3D parts and assemblies.

This ¡s what I currently have ¡n my table which I am pulling my data:

1 Part Number Part Name Part / ASM Start Date End Date Modeling Time (in days)
2 Working Days
3 (Excludes weekends)
4 2624264 Guide, Cabinet Part 2/17/20 14 2/17/2014 1
5 2624267 Rod, Cabinet Part 2/18/2014 2/18/2014 1
6 2624268 Bar, Cabinet Part 2/18/2014 2/18/2014 1
7 5433137 Bracket, Ammunition Box Asm 2/20/2014 2/22/2014 2
8 5433137-001 Bracket Part 2/20/2014 2/2 0/20 14 1
9 5433137-002 Plate Part 2/20/2014 2/20/2014 1


To create a 3D model a ‘Part’ it is simple:

To model a 3D ‘Asm’ (Assembly) it may take more time…thus I need to distinguish these two different variables in my table.


Here is what I get:image

Here is what I would like:

Final Chart with Part ASM in Table

Thanks – Kevin”


First, see if you can replicate the chart.

Then is what Kevin asking possible?

If not, how would you do to help Kevin?

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

Donate with PayPal here:

Leave me a comment with your email address if you would like to submit a response.



Please enter your comment!
Please enter your name here