While creating pareto chart, I came across a problem of axis resizing. Suppose, in my City dropdown I have selected "All" then the chart looks good with its original size, but if I select any city from dropdown, pareto chart contracts as it has less number of customers which results in a white blank space on the right side of my chart. This is only for pareto chart, while for other charts chart remains same size as before.
Is there any way by which I can fix its size and does not depends on the number of customers on x-axis?
Attached is the sample workbook for the same.