I don't recall the exact problem. I think you get an error, like a formula
references an invalid range, in an existing 2003 chart. In a new 2007 chart,
it just doesn't accept the name as valid source data, and won't dismiss the
dialog.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Barb Reinhardt" wrote in message
...
Jon,
I can put something together to create range names, delete range names and
update the chart series. I don't need assistance with that, but thanks.
What is the symptom in Office 2007? Can you not create range names
starting
with chart? If they are in a chart series, will they not display?
Barb Reinhardt
"Jon Peltier" wrote:
I know this is frustrating. It hardly makes sense to ask why, because the
answer will be along the lines of "because". I think it's probably an
oversight. I don't know of a way to change the charts if they are already
in
2007, but I'm thinking that it might not hurt to try writing a little
macro.... Maybe if you check my blog in a few days.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"Barb Reinhardt" wrote in
message
...
I have a workbook that has range names starting with Chart and other
range
names that are offset from that one. I'm thinking at least 100 are
affected. I know I can write a macro to change the names, and the
series
that use them, but why can't they start with Chart in Office 2007?
This
is
going to be a lot of work to update.
Thanks,
Barb Reinhardt