View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
cate cate is offline
external usenet poster
 
Posts: 93
Default charts; myChart.SeriesCollection(10).Name; lots of quotes

On Dec 10, 10:09*pm, Jon Peltier wrote:
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.


2003
Yes, that's what I did. But I run into so many "things" I just wanted
to be sure. Thank you.