I have a scatter with smooth lines chart in excel 2013. The values on the primary y-axis range from -4 to 4 (excel automatically created this range). I have one series graphed relative to this primary y-axis. I have graphed another series relative to a secondary y-axis. This secondary y-axis must be related to my primary axis by the following ratio: 1 unit (in this case 1 inch) on the primary axis must equal 0.514475 units (in this case percent) on the secondary axis. Because of this ratio relationship I had to manually change the maximum and minimum bounds on the secondary axis to 2.0579% and -2.0579% respectively. My problem is two fold. One, the tick marks are not anchored about zero. Two, if I change my "Major Units" to force the tick marks to land exactly on zero, then the rest of the tick marks are not clean increments (example: -1.5, -1.0, -0.5, 0, 0.5, 1, 1.5). Is there a way that I can anchor the tick mars about zero on the secondary axis, increment these tick marks in clean number increments (like the aforementioned example), and still have the secondary axis be related with a ratio to the primary axis? Any help would be very welcome as I am completely stumped on a fix. A VBA fix is not preferable as I am not proficient in VBA. Thanks.
Here is a picture of my current chart. Note that the blue line actually has an orangish line underneath it. One series corresponds to the primary axis and the other series corresponds to the secondary axis, and both series currently occupy the exact same space on the graph because I have the axis related by the ratio I have already mentioned.
Capture.PNG
Bookmarks