Can you link the value of an x-axis min value to a cell?

[puffy]

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

 

[Tushar Mehta]

Unfortunately, you have to do this programmatically.

For a readymade solution, check the AutoChart Manager add-in, available
from my web site.

For a roll-your-own solution, see Jon Peltier's
http://www.geocities.com/jonpeltier/Excel/Charts/AxisScaleLinkToSheet.h
tml

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions