I have created a line graph with 2 legends. The graph is creating fine, but because of the two separate data sets, the bounds for each legend are different and makes comparisons redundant.

I know I can adjust the bounds in the format section, to make "legend 2" = "legend 1". But this isn't good for me, since it is a dynamic graph and by adjusting cells B2 and B3, this will adjust the graph and the bounds accordingly. I cannot set them to a big range, because the values range from 0.0003 to over 1,000, but the values that are pulled into the graphs are usually within about 10% of each other.

For example, I am pulling in Rates.
B2 = USD
B3 = EUR

A line graph is then created with 2 different kinds of rates which i am comparing (all between 1.3 and 1.05), but then I can adjust B3 to equal JPY and then the graph will change to between 100 and 140, but when this change happens. On 'Auto' bounds, the 2 legends are not even.

How do I fix this?