Hi
My question: is there a way, in a macro to change the range of a line chart. Let's say, the last sale of the stock is 75 The range of the chart is 60 to 90. If the price of the stock went to 85 the macro would change the range to 70-100. The macro would change both sides of the range by a predetermined amount, let's say 15 points. If it went to 95 the range would change to 80 -110. Conversely if the stock was at 75 and it went to 65 the chart would change to 50-80. I have no idea it this would actually work, but I have to ask.
Thank you,
Paul Gaconnier
If you would like to look at my charts go to stocktrac.net