A macro that changes the color of the bars in the chart

Hi, I have a macro for the chart that changes the colors of the bars but I would need help because I need to modify them a bit. The idea is that the chart is generated on the basis of data from the area, which is marked in gray (in this case, the cell colors I marked only to better distinguish what is going on) and whether it will be marked green or red on the graph to be generated on Based on the values ​​from the area in the green color and the limits whether the value should be green or in red are in the table yellow.

Please Login or Register  to view this content.