please see enclosed workflow. I need to put the value of the variable TP1 somehow centered over the columns BB1-BB4 and then the value of TP2 centered over BB5-BB9. If i could do this in the title of the chart "industry3" that would be great, but if i can't, I could do it as a text box. I tried just a text box with the text =$(TP1) but that just gives me a blue box with a dot in it. I'm sure this is really easy - ideas? thanks
how do I add text to the variables though? one needs to just be =TP1 and one needs to be "retail share is =TP2" and i cant seem to get the text part to work. thanks
the spacing is still off, i need the first value to be over the first 4 numeric columns and the next over the next 4 columns. is that possible?
so far, i have this
=TP1& 'Retail Share '&TP2
and that gets me the data but not the spacing. how do you know where to put the &?
Glad I am able to help you...
Let me break it down the expression:
=TP1 &' ' &'Retail Share '&TP2
TP1 <---- will get the value from the field
&' ' <--- & is to concat. It is concatenating spaces here
&'Retail Share ' <--- again you are using &, meaning concat 'Retail Share'
&TP2 <--- Once again you are concatenating the value of TP2 here.
Note: & <-- it is like concat or join. By using the ampersand you are joining different values.
Hope this helps...