Prev: Finding second data point on primary axis of two axis chart
Next: Where can I get a free gauge chart for excel?
From: cate on 10 Dec 2009 10:26
With the goal of some VBA later, I am 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.
 | 
Pages: 1
Prev: Finding second data point on primary axis of two axis chart
Next: Where can I get a free gauge chart for excel?