Cyberdude
12-19-2005, 10:53 AM
On some of my charts I like to use an automatic maximum for the horizontal scale so I don?t have to keep changing the maximum as time marches on. This works well unless I have a horizontal line plotted that I want to go to the right edge of the chart (or beyond).
The auto max scale guarantees that I can never make a horizontal line extend to the right edge of the chart because it likes to have blank space between the right end of a plotted line and the right boundary of the chart. If I increase the limit of the plotted horizontal line so that it reaches the right edge of the chart, then the auto scale kicks in to increase the scale an equivalent amount, so the blank space appears again. (Am I explaining this adequately?)
As a not-so-good substitute, instead of plotting the horizontal line, I use an AutoShape line that floats in approximately the right position. In some cases, I want the left end of the horizontal line to be a plotted point that moves with the chart. That makes it necessary to stop using the auto max scale feature.
My question is, how can I use an auto max horizontal scale AND plot a horizontal line that goes to the right edge of the chart? http://vbaexpress.com/forum/images/smilies/102.gif
The auto max scale guarantees that I can never make a horizontal line extend to the right edge of the chart because it likes to have blank space between the right end of a plotted line and the right boundary of the chart. If I increase the limit of the plotted horizontal line so that it reaches the right edge of the chart, then the auto scale kicks in to increase the scale an equivalent amount, so the blank space appears again. (Am I explaining this adequately?)
As a not-so-good substitute, instead of plotting the horizontal line, I use an AutoShape line that floats in approximately the right position. In some cases, I want the left end of the horizontal line to be a plotted point that moves with the chart. That makes it necessary to stop using the auto max scale feature.
My question is, how can I use an auto max horizontal scale AND plot a horizontal line that goes to the right edge of the chart? http://vbaexpress.com/forum/images/smilies/102.gif