While I'm waiting for my response, I'll see if I can help you. Did you: Select axis, right click to edit axis, select "fixed" range, enter zero at minimum, and leave maximum alone (should show your max value). I don't know if this would reset if you linked to new data. If it does, sounds like you want to save a chart template. hth, Cheers.
This sort of works, but because the data is always changing, the max value today may not be the max value next week.
Can you help me understand "save a chart template"?