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