I am running a macro to reset the scales of a chart. I'm running into a problem when I have a negative number. I would like to have the following major units on the secondary axis(100%, 80%, 60%, 40%, 20%, and 0% or a negative % if applicable). As I have it now, the negative number causes the major units to adjust down to 97%, 77%, 57%, 37%, 17%, and -3%. is there a way to set the major units separately or another way to change this with VBA. Attached is the file with macro.
Bookmarks