Trying to graph the effect of an exchange rate on profit/loss for a portfolio. My charting skills are fairly poor and the only way I've been able to do this has been dragging out several thousand values (ranging from about 0.64 to 0.96) against the profits that each rate produces.
Is there some way I can set it to a continuous range (from 0 to infinity) rather than manually entering the exchange rates? Obviously in my chart I'll only show a fraction of these but I need to be able to show data for basically any exchange rate.
Thanks
Bookmarks