Hi,
For my job I was asked to create a chart showing a loss tolerance range, expressed in basis points, with next year's expected loss rate plotted as a point within the range. Until today I was able to do this using the stock chart (high-low-close), with high and low representing either ends of the loss tolerance range, and "close" representing next year's planned losses.
Today I was asked to add the last two years' actual loss rates to the range as well, and I can't for the life of me figure out how to do this without manually dropping an auto shape on the range to approximate where it would be.
Is it possible to accomplish what I'm trying to do?
I quickly drew up what the final product should look like in Paint, which you can find attached.
Any help with this would be hugely appreciated! Thanks in advance!
Bookmarks