Thread: 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

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" <Charlene@discussions.microsoft.com> wrote in message
news:CE687B49-D1D8-49DD-BA32-A276A3B32BC6@microsoft.com...
> 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

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