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?

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