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.

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.

On Dec 10, 10:09*pm, Jon Peltier <jo...@SPAMpeltiertech.com> 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.