Try replacing 'Raw Data' with the workbook name. If the name resides on a
different sheet, then 'Raw Data'!BlahBlah may raise the error.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"ChrisG" wrote in message
...
OK, I think i have the answer to that question, but I am still having
problems. My worksheet is called "Raw Data." But when I click on an
empty
cell to create my graph, I enter "='Raw Data'!$B$1" into the name box, but
when I enter "='Raw Data'!ChartEuropeanEquity" I get a message that says
"Your formula contains an invalid external reference to a worksheet.
Verify
that the path, workbook and range name or cell reference are correct, and
try
again." What is wrong with the formula that I have written? Thanks for
your
help,
Chris
"ChrisG" wrote:
Thanks for your help Jon, I am using the "Dynamic Charting By Dates
(TechTrax
Article)" However, when I am actuallty creating the chart, when I enter
"=Data!ChartFirmA" (except I have a different name besides "FirmA") I get
an
error message that says "Reference is not valid. Reference must be to an
open worksheet." What does this mean, what did I do wrong, and how can I
correct it? Thanks for your help,
Chris
"Jon Peltier" wrote:
See Dynamic Charts:
http://peltiertech.com/Excel/Charts/Dynamics.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"ChrisG" wrote in message
...
I have a worksheet full of raw data and other worksheets which are
just
charts based on the raw data. I continually add more data to the raw
data
worksheet, and I was wondering if there is a way to change the source
data
of
the chart so that it will automatically update if the raw data
changes.
To
clarify this, I will give an example. If on Monday I have 5 rows of
data
and
every day that week I add more rows, so that by friday I have 10 rows
of
data
(with the most recent data comprising the top row), can I have the
chart
automatically include all of the data? Thanks for your help