How to add to existing chart title and loop through

What is busUnit in you dotitles routine?

Also I think your Replace function has the wrong argument values.

Replace(expression, find, replace[, start[, count[, compare]]])

The Replace function syntax has these named arguments:

Part Description
expression Required. String expression containing substring to replace.
find Required. Substring being searched for.
replace Required. Replacement substring.
start Optional. Position within expression where substring search is to begin. If omitted, 1 is assumed.
count Optional. Number of substring substitutions to perform. If omitted, the default value is –1, which means make all possible substitutions.
compare Optional. Numeric value indicating the kind of comparison to use when evaluating substrings. See Settings section for values.

Once you have proper value in busUnit then you should just be able to concatenate the text

Please Login or Register  to view this content.

You can't use the whole array as prefix to chart title. You need to specify which item in busUnit to use.

for example

Please Login or Register  to view this content.