Setting axis parameters for a chart in the worksheet

's Computer Specifications

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

's Computer Specifications

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 (E-Mail Removed)> wrote in message
news:05B02C6C-4459-4655-98D3-(E-Mail Removed)...
>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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Setting reverse order for axis in OWC 11 chart component	JoeG	Microsoft Excel Charting	6	9th Apr 2009 01:09 PM
setting axis from columns without using row number for line chart	williamj	Microsoft Excel New Users	1	1st Aug 2008 05:31 PM
Editing worksheet tabs & chart/axis labels	Gregory	Microsoft Excel Discussion	0	16th Mar 2007 05:31 PM
Error when setting chart Axis value	Job	Microsoft Excel Programming	1	6th May 2005 05:04 PM
Manually setting Y-axis values in line chart	chris w	Microsoft Excel Worksheet Functions	2	11th Jun 2004 09:20 PM