Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to create a chart in excel with data from another workbook
Can you please tell me how i can create a chart in one workbook using data
from anothe workbook. I also want to link this chart to the table so it gets updated automatically |
#2
|
|||
|
|||
Does just referenceing the other workbook not do it?
If you need to look at where the source data comes from... Right click in the chart somewhere and you should see the option "source data" click on it and you will see you where the data is sourced from for each element of the graph. Any use? Andrew www.jmdata.co.uk "Charlene" wrote in message ... Can you please tell me how i can create a chart in one workbook using data from anothe workbook. I also want to link this chart to the table so it gets updated automatically |
#3
|
|||
|
|||
There are several ways to add a new series to a chart. The easiest way to add data
from a different workbook (or worksheet) is to copy the data in that workbook (sheet), select the chart, and use Paste Special (Edit menu) to add the data as a new series. In the Source Data dialog (Chart menu), Series tab, you can add a series, click in the various input boxes, then use the sheet tabs and windows menu to navigate to other sheets and workbooks to select the data range. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Charlene wrote: Can you please tell me how i can create a chart in one workbook using data from anothe workbook. I also want to link this chart to the table so it gets updated automatically |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create excel spreadsheet on a data access page | Excel Discussion (Misc queries) | |||
Conditional formatting of a data series in an Excel Chart? | Excel Discussion (Misc queries) | |||
How to create a line chart with two X-axes in Excel | Excel Discussion (Misc queries) | |||
Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel |