Linking a chart

[changetires]

Can you link a chart on one sheet to the data on another sheet to automatically update the chart when more or new data is added to the data sheet? Any ideas would be helpful.

Thanks

Ed

[Andy Pope]

Hi,

See Jon's pages for information on both parts of your question.

On different sheets
http://peltiertech.com/Excel/ChartsH...iffSheets.html

Dynamically extending data in charts
http://peltiertech.com/Excel/Charts/Dynamics.html

Cheers
Andy

changetires wrote:
> Can you link a chart on one sheet to the data on another sheet to
> automatically update the chart when more or new data is added to the
> data sheet? Any ideas would be helpful.
>
> Thanks
>
> Ed
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info