Hover over text on dimension in pivot chart

[SureshUK]

Hi,

I have a pivot chart with few dimension and summarized value.  Due to lack of space, I could not include the description of the dimension in the chart.

I am looking to introduce a mouse over so that when the use hovers over the dimension, the description has to appear on top.

How do I achieve this?

Thanks

Raj

[sunny_talwar]

You want something like this?

I used a calculated dimension like this

=Dim & Chr(10) & Description

So, when you are not hovering, you see this

[sunny_talwar]

I used a straight table, but the same works for a pivot table also

[SureshUK]

I tried that before. It has line size 2 because of other columns and it is resulting in additional text "...." to appear at the bottom of the code! Can you think of a way to get rid of it?

[sunny_talwar]

Can you think of a way to get rid of it?

Unfortunately not