linking values of a worksheet into a chart

[emgee]

Dear xcellers,

I know there exists a feature to put a graphic copy of parts of a sheet onto the sheet itself. Updating the sheet will automatically update that graphic part; now I would like to have that functionality into a chart;
So make a chart (any type) and then link part of the sheet also into the chart; in such a way that if that part of the sheet changes the linked part also changes; Any suggestions??

Thank you in advance

Marcel G

 

[GlennUK]

Have you tried using the camera tool. Customize a toolbar and add the camera tool to it ( it's in the Tools category ).

Select the area of the worksheet you want to appear in the chart, press the camera tool, select the chart and click your mouse, and it's done.


Glenn.