Automatic Grid Space

[ptc-2040632]

Hi everybody,
I want to change the grid distance in a plot automatically depending of a distance between two variables.
F�r example:

y1:= 17
y2:= 0

I want the gridspace in the plot to be changed to 17 by itself, without having to click format and so on.

Anyone who has an example, or a solution, or any suggestions???

Best regards
Henric Karlsson
Stockholm, Sweden

[wayne]

The place holders that appear on the graph when the graph is placed on the sheet allow variables.
Often I want the graph to extend just past maximum values so I can see the ends, which sometimes overlap the graph box. So I sometimes use 1.1*ymin (if negative values) and 1.1*ymax as the limits,for example.

Wayne

[ptc-1368288]

OK Wayne,

But that does not allow for smart look gridding on a fixed number of grids. And to make it worse, the collab wants 17 grids . Just comment that would deserve the work sheet.

jmG

[RichardJ]

Putting a grid on it is easy enough, but there is no way to make the grid lines match up with the tick marks, because there is no way to programmatically set those.

Richard