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

  • Thread starter Thread starter German Galvez
  • Start date Start date
G

German Galvez

I need to insert a table of data that is different for the data used in the
chart (series).
 
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
 
Back
Top