Setting axis parameters for a chart in the worksheet

I have a worksheet that replicates a project gannt chart and would like to
set the date parameters from the min/max function in the worksheet.

Can I set a link/range name from from the format axis/scale tab that will
grab the worksheet cell data?

Thank you

Hi,

With the help of VBA you can link the charts axis parameters to cells.
http://peltiertech.com/Excel/Charts...inkToSheet.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Steve S" <Steve S@discussions.microsoft.com> wrote in message
news:05B02C6C-4459-4655-98D3-FA27ECD30CE4@microsoft.com...
>I have a worksheet that replicates a project gannt chart and would like to
> set the date parameters from the min/max function in the worksheet.
>
> Can I set a link/range name from from the format axis/scale tab that will
> grab the worksheet cell data?
>
> Thank you