View Single Post
  #1   Report Post  
PKyle
 
Posts: n/a
Default Graphing Question- rescaling

I have a spreadsheet where I have the user use slide controls to specify the
min, max X scale values. The resulting graph rescales itself. When I have
a small span, the line of the graph is a small part of the displayed scale,
and when I open up to a larger X-scale range- the line takes up more of the
displayed chart.

Is there a way I can pull the values from min X and max Y, and MinY and Max
y values from the table and make them the default values for rescaling the
graph???????? I couldn't enter cell values in the rescaling fields under
graph settings- it would only take numeric values.


Thanks

Paul (not a macro expert)