Can someone help me with the below visual?

Hi JaydipPatel81,

Creating a clustered column chart with one of the columns being stacked is perhaps not the correct visual choice here. Showing bars in this way is less intuitive to perceive visually and takes longer to process cognitively for your viewers than, say a Bullet Chart.

There's a few bullet chart visuals in the marketplace, and I use them a lot for similar use cases as yours.

I've listed in my personal order of preference, but see how you get on with them:

• Bullet Chart by OKViz 
• Bullet Chart - xViz 
• Bullet Chart (Microsoft)

Not exactly the answer you were hoping for, but it's generally regarded as the most effective way to handle this particular visualisation challenge.

Good luck!

Daniel

If my post solves your challenge, then please consider accepting as a solution to help other forum members find the answer more quickly 🙂