Chart axes

[Gareth Milton]

How do I link the chart range to worksheet entries, as
oposed to entering it on the "Format Axis" box?

 

[Tushar Mehta]

You have to do it programmatically, using something like
AutoChart Manager
http://www.tushar-mehta.com/excel/software/autochart/index.html

--
Regards,

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