Graphs - x axis label range

[Guest]

I have a simple graph where I plot certain water flows (y axis) against time (x axis) in units of months. The range that defines the x axis min. and max. limits changes very frequently, necesitating redefining the x axis label range manually. Is there a way of linking the upper and lower limits of the x range (or y range Min. & Max. for that matter) with a formula in the spreadsheet? I've tried using the INDIRECT function, but that doesn't work. Defining the Min. Max. and ranges to be graphed appears to only be do-able by setting them manually (or using the pointing method) through the Chart's source data or scale settings (or by defining a macro to do that for you).

 

[Damon Ostrander]

Yes, I should have spotted that. You can't set the MinimumScale or MaximumScale properties of a category axis unless the chart type is a scatter plot. But also now looking back at your problem I realize it should have been obvious that you really wanted the value axis.

Damon