What version of Excel? (I think I know...)
Just use this:
ActiveChart.SeriesCollection(10).Name = "NBT"
- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/
cate wrote:
Playing with charts and saw this in a recording:
ActiveChart.SeriesCollection(10).Name = "=""""""NBT"""""""
I was changing the name of a series to a text string of NBT. What is
the reason for all the quotes.?
FYI. Using a range (I selected the cell with the name as a text
string" gives this:
ActiveChart.SeriesCollection(10).Name = "=Sheet1!R26C2"
Thank you.