ExcelBanter - How can I insert a table of external data in a chart?

Select the range containing the data. Hold the Shift key, go to Edit menu,
select Copy Picture, and use the On Screen and Picture options. Select the
chart and paste. You get a picture of the copied range.

To make it dynamic, simply copy the range, select another cell, hold Shift
and go to the Edit menu, and choose Paste Picture Link. You get an active
picture of the range. Select the picture and the formula bar says something
like =$B$1:$E$2. Insert the sheet name so it reads =Sheet1!$B$1:$E$2. If the
sheet name contains a space, wrap it in single quotes, ='My
Sheet'!$B$1:$E$2. Copy this linked picture, select the chart, and paste.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

"German Galvez" <German wrote in message
...
I need to insert a table of data that is different for the data used in the
chart (series).