I was wondering if it is possible to fill a bar chart up to a certain point. Or to have a way to stack a certain value in front. Here is a sample incorrect that I would like to fulfill:
I would like to fill a different color if possible up to the plan total of 54.5% which would be 97.8% of the overall June value. If that is not possible, is it possible to put a bar graph in front of June, with the Plan value. If this is possible please share the syntax how to complete.
Thank you for the suggestions. Since the difference in this example is so small, the stacked bar does not look good. What I would be looking for would be a way to fill the bar color up to a certain point. I know how to change the color of the bar graph in total, but is there a way to color a portion based off of a function?
Say I wanted to change the color of the above bar graph to green I would put in green(). If I wanted to use an if statement to change it only if the value is over 1, then I would use an if statement. Is there a way to use an if statement or other formula to color a bar for only 60%, and have the rest of the bar the original color? Or is there a better way to stack given user requirements?