G
Guest
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).