In case someone else has this problem, make sure that the secondary axis is not set to "Automatic" under Chart Options. "Automatic" is ... automatic.