View Single Post
  #1   Report Post  
Hari Prasadh
 
Posts: n/a
Default Scaling of graphs through formulas

Hi,

Is it possible to control the Maximum X scale value and Minimum Y scale
value based on the DYNAMIC changing data in Excel sheet.

Like I would like to set Minimum to 0.9*Min(B1:B15) and Maximum to
1.1*Max(B1:B15) or whatever based on my whims (basically I would like it to
be formula based or linked to a particular cell).

Is that possible?

Thanks a lot,
Hari
India