Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to cutsomise tooltips and im adding the required information which is working great but i am just not able to break it to different lines despite trying chr(10) & chr(13). Currently im trying
='City: ' & CityName & chr(10) &
'Product: ' & ProductName & chr(10) &
'Opportunities: ' & Totalopportunities & chr(10) &
'Challenges: ' & Count(challenges)
I want to show all these in different lines in the tool tip. Please suggest how to do it or any alternate way to achieve this
Hi @Zirva,
Use like below:
Dual(Expression1 & Chr(10) & Expression2 & Chr(10) & Expression3, Expression1)
//Expression- This is for data points what you get
Or
As your Expression:
Dual(
'City: ' & CityName & chr(10) &
'Product: ' & ProductName & chr(10) &
'Opportunities: ' & Totalopportunities & chr(10) &
'Challenges: ' & Count(challenges),
Num(Totalopportunities)
)
***Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.***
Hi @TauseefKhan ,
thanks for the support but I tried this but it doesnt work. Still doesnt take each to the next line. I believe the tool tip doesnt recognise chr(10) or <br> functions. Is there any other way we can achieve a line break?
Use both chr(10) and chr(13) together to create a new line in the tooltip text:
'City: ' & CityName & chr(10) & chr(13) &
'Product: ' & ProductName & chr(10) & chr(13) &
'Opportunities: ' & Totalopportunities & chr(10) & chr(13) &
'Challenges: ' & Count(challenges)
Try this:
='City: ' & CityName & chr(10) &
'<br> Product: ' & ProductName & chr(10) &
'<br> Opportunities: ' & Totalopportunities & chr(10) &
'<br> Challenges: ' & Count(challenges)