Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I insert a table of external data in a chart?
I need to insert a table of data that is different for the data used in the
chart (series). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table accessing external data | Excel Discussion (Misc queries) | |||
How to Insert a table into an excel chart | Charts and Charting in Excel | |||
Import External Data Non-HTML Table | Excel Discussion (Misc queries) | |||
Get External Data - Insert Rows | Excel Discussion (Misc queries) | |||
Pivot table using External data | Excel Discussion (Misc queries) |