Autoscaling a chart
 

Hi everyone, I've built a model where all the variables are calculated
in several currencies. This model has a macro that refreshes a chart.
The problem is that when I change currencies the charts are completely
off scale. Is there a way to automatically scale the chart according to
the data series it shows?? Thanks