Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)?