reg-alignment of tables

[#1]

Hi All

i have multiple pivot table reports nad i have created a lables for all reports on top hem

i created lables with text obj

  ACT 15            BUDGET 15              MONTHLY AVARAGE

These lables should come for all reports,but the problem is all the reports are not in same size

if i click on second report the label size is diff

can any one saove this prob

[eespiritu]

Hi,

Can you share a screenshot as example?

[sundarakumar]

Hi,

I think there is no straight solution for moving the text objects dynamically. You can use macros to do the same.

PFA the macro to dynamically realign charts.

I would prefer to use the caption of the Pivot tables to specify the name instead of text boxes.

Regards,

Sundar