Align chart and table axes together with filter selection

[udaya_kumar]

Hi,

I have placed chart at the top and a table below to that chart like one below another.

I have the names in the x-axis in the bar chart and I have dragged and dropped the name dimension to horizontal in pivot table and aligned these names to that of the bar chart x-axis.

For some date selection, the x-axis is having some 7 names and for few date selection, the x-axis is having 6 names.

Because of these difference in no. of values in the x-axis, the table and chart values are not aligned properly together.

IS there a way to align both x-axis and the table values (Pivoted to horizontal) together based on the filter selections.

Thanks,

Uday

[udaya_kumar]

Is there a vbscript code to get the width and height of an object (Pivot table) and apply the same width and height to another object (Chart)?