"S" Shape Indicator - Help / Support Need

[DrHacker]

Well, here is a good challenge that i cant solve it... Probably any of you can support with a solution.

I want to create a Monthly Status "S" Shape Indicator divided by 31,30 & 28 (February) based on aplicable active month.

Probably any of you can help me with a solution and/or how to do it.

Thanks!

Attached you will find a picture of the "S" that i want as sample.

 

[Fluff]

Cross posted

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered elsewhere.

Please supply all relevant links.

 

[DrHacker]

Fluff - Thanks for advice. Here is Cross Post Link: https://www.excelforum.com/excel-charting-and-pivots/1329902-s-shape-indicator-help-support-need.html

 

[Eric W]

I'm not sure you're going to get exactly what you want. The only way I can imagine it is to create 31 shapes, that when fitted together make an S shape. Then you could use VBA to change the fill color of certain of those shapes to provide the shading. That sounds quite tedious, and you'd have to repeat it twice more for 28 and 30 (even 29). As an alternative, you could create a WordArt shape of an S, then use VBA to change the color gradient as desired. See here: