Creating a dynamic stacked bar chart with conditional formating and labels reading from cells

%3CLINGO-SUB%20id%3D%22lingo-sub-1256169%22%20slang%3D%22en-US%22%3ECreating%20a%20dynamic%20stacked%20bar%20chart%20with%20conditional%20formating%20and%20labels%20reading%20from%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1256169%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20been%20trying%20to%20create%20a%20stacked%20bar%20chart%20per%20TM%23%20for%20the%20below%20that%20takes%20into%20consideration%20the%20order%20of%20the%20activities%20in%20each%20line%20where%20each%20category%20(Manual%2C%20Aux%2C...)is%20in%20its%20separate%20unit%20in%20the%20stacked%20bar.%20Machine%20is%20not%20counted%20in.%3C%2FP%3E%3CP%3EI%20also%20wanted%20to%20do%20a%20conditional%20formatting%20that%20it%20takes%20activity%20name%20and%20duration%20plus%20conditional%20format%20them%20so%20it%20takes%20the%20manual%20into%20green%2C%20auxiliary%20into%20yellow%20%2C%20walk%20and%20wait%20into%20red.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20only%20thing%20I%20managed%20to%20do%20is%20to%20create%20the%20stacked%20bar%20chart%20in%20order%20but%20couldn't%20have%20the%20labels%20update%20and%20refresh%20with%20any%20changes%20I%20do%20in%20the%20original%20table%20which%20will%20affect%20my%20pivot%20table%20or%20even%20the%20colors.%20Below%20is%20also%20a%20hand%20chart%20of%20how%20I%20want%20the%20chart%20to%20look%20based%20on%20the%20below%20example%20and%20keeping%20in%20mind%20that%20data%20will%20always%20change%20and%20TM%23%20can%20increase%20or%20decrease.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Chart%20Drawing.jpg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F179750iD573F6C1F019B7F1%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Chart%20Drawing.jpg%22%20alt%3D%22Expected%20chart%20drawing%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EExpected%20chart%20drawing%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22Dynamic%20data%20table.jpg%22%20style%3D%22width%3A%20840px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F179746i0667F8C6AE319E92%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Dynamic%20data%20table.jpg%22%20alt%3D%22Dynamic%20data%20table.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1256169%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2275818%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20a%20dynamic%20stacked%20bar%20chart%20with%20conditional%20formating%20and%20labels%20reading%20from%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2275818%22%20slang%3D%22en-US%22%3EHey%20did%20you%20get%20a%20solution%20for%20this%20problem.%20If%20yes%20please%20help%20me%20out%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, I have been trying to create a stacked bar chart per TM# for the below that takes into consideration the order of the activities in each line where each category (Manual, Aux,...)is in its separate unit in the stacked bar. Machine is not counted in.

I also wanted to do a conditional formatting that it takes activity name and duration plus conditional format them so it takes the manual into green, auxiliary into yellow , walk and wait into red. 

The only thing I managed to do is to create the stacked bar chart in order but couldn't have the labels update and refresh with any changes I do in the original table which will affect my pivot table or even the colors. Below is also a hand chart of how I want the chart to look based on the below example and keeping in mind that data will always change and TM# can increase or decrease.

 

Expected chart drawingExpected chart drawing

 

Dynamic data table.jpg

 

 

1 Reply
Hey did you get a solution for this problem. If yes please help me out