When adjusting the axis scale in any excel chart, is it possible to
make the minimum (or maximum) refer to a cell or cell name?  To me it
seems like excel only accepts hard-coded numbers...

The reason I need this is as follows:
We are tracking certain metrics on a weekly basis, and would like to
graph these each week.  The front page of charts will have the six
most important charts only.  So in one week, the chart in the top left
corner may represent total revenue, while in the next week it might
represent profit margin - same chart, different scale required!

TIA
puff