Skip to main content
P
ptc-20406321-Visitor
1-Visitor
April 29, 2010
Question

Automatic Grid Space

  • April 29, 2010
  • 2 replies
  • 2850 views
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

2 replies

R
RichardJ19-Tanzanite
19-Tanzanite
April 29, 2010
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
W
wayne12-Amethyst
12-Amethyst
April 29, 2010
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
P
ptc-13682881-Visitor
1-Visitor
April 29, 2010
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
Terms & ConditionsAccessibility statement