Link a cell to min & max box for Value (X) axis scale?

You have to do this programmatically. For a readymade solution see
AutoChart Manager
http://www.tushar-mehta.com/excel/so...art/index.html

--
Regards,

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

In article <3F481484-0DA2-4849-853C-EA313FD142BA@microsoft.com>,
cwilliams@discussions.microsoft.com says...
> I want to update the min and max box of the Value (X) axis scale without
> having to click on the axis, select the tab and type in the min and max times
> for each scale for each chart.
> Can I assign a cell in the spreadsheet so that its value will be used in the
> min and max boxes?
>
> Does anyone have a suggestion on how to best accomplish this?
>
> Thanks,
>
>

I had just found the Autochart manager and installed the add-in. I found a
link from J. Peltair's site to yours. Great add-in! I would like to be able
to specify the major increments also.

"Tushar Mehta" wrote:

> You have to do this programmatically. For a readymade solution see
> AutoChart Manager
> http://www.tushar-mehta.com/excel/so...art/index.html
>
> --
> Regards,
>
> Tushar Mehta
> www.tushar-mehta.com
> Excel, PowerPoint, and VBA add-ins, tutorials
> Custom MS Office productivity solutions
>
> In article <3F481484-0DA2-4849-853C-EA313FD142BA@microsoft.com>,
> cwilliams@discussions.microsoft.com says...
> > I want to update the min and max box of the Value (X) axis scale without
> > having to click on the axis, select the tab and type in the min and max times
> > for each scale for each chart.
> > Can I assign a cell in the spreadsheet so that its value will be used in the
> > min and max boxes?
> >
> > Does anyone have a suggestion on how to best accomplish this?
> >
> > Thanks,
> >
> >
>