Dim Line Labels?
 

I am dealing with a macro that makes several graphs. The label for the
lines of the graphs depend on the number attached to the name of the
file. I do not want to have to go into the VB code and find and replace
the numbers for each of them. Is there anyway I can write this at the
top and have it go for each of them? I tried this earlier with no
sucess, but I will post it to help you better understand what I am
talking about. It looked something like this:

Dim plot300K as Name
plot300K = "13T300K2per0500"



ActiveChart.SeriesCollection(1).Name = "=""plot300K"""


--
Losse
------------------------------------------------------------------------
Losse's Profile: http://www.excelforum.com/member.php...o&userid=24813
View this thread: http://www.excelforum.com/showthread...hreadid=386782

Dim Line Labels?
 

Dim plot300K as String
plot300K = "13T300K2per0500"
ActiveChart.SeriesCollection(1).Name = plot300K


--
Rich_z
------------------------------------------------------------------------
Rich_z's Profile: http://www.excelforum.com/member.php...o&userid=24737
View this thread: http://www.excelforum.com/showthread...hreadid=386782

Dim Line Labels?
 

I tried that before switching over to Dim as Name. When I dim it as
string, it simply gives it the name "plot300K."

Edit: Nevermind. I had forgotten to take the quotation marks out

--
Loss
-----------------------------------------------------------------------
Losse's Profile: http://www.excelforum.com/member.php...fo&userid=2481
View this thread: http://www.excelforum.com/showthread.php?threadid=38678

Dim Line Labels?
 

Because you had the string Plot300k in quotes.

Remove the quotes and it becomes a variable rather than a string
constant


--
Rich_z
------------------------------------------------------------------------
Rich_z's Profile: http://www.excelforum.com/member.php...o&userid=24737
View this thread: http://www.excelforum.com/showthread...hreadid=386782