The images of what I want, and what I get after my macro runs are attached below. Basically, I cannot find a way for the macro to change certain aspecs of my graph.

Specifically, I need to be able to customize the gradient (I have to set certain stops with certain colors in order to get the red/green I need), be able to change the size of the data label font, and be able to get the data label font on its side.



whatiget.PNGwhatiwant.jpg