I don't know if this is possible but either in cells or in a bar chart I'd like to create just 1 bar that changes color and height based on the value thats provided. Ideally it would even break it down further to where it would stack numbers with a green/yellow/red so 1 continuous bar might be 3 different colors and also be say 80% of the total height if it was 80% complete.

Basically I want to trend production for shifts in a particular job. The green/yellow/red would be how well the shift produced and the total percentage would be how much has been produced for the total job amount. So say in 3 shifts we have 20,000 (red), 100,000 (green), and 50,000 (yellow) and the job size is 200,000. That would be 85% of the total height.

This is my basic structure but I'd like to get into more detail from there. I'd appreciate it if anyone could help me. Thanks