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

Setting axis parameters for a chart in the worksheet
 

Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Steve S" <Steve wrote in message
...
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