Thread: Auto Y Axis based on the max cell value in a range

I'm making a dynamic pareto chart in Excel.
I want:
1. Auto srting of data as we enter
2. to fix the Y max value as the sum of a range.
w can we do that?
A file is attached here for ref.

Thanks in advance.