Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there is way to not to change size of the chart.
I have two dimension and one expression in pivot chart.
2nd dimension is collapsed .so it will show 1st column and expression
when i expand it the size of the chart should remain same and also expression column width should be same.
PFA QVW and Excel for reference
Hi balraj,
1st figure shows always expanded ,which i dont want.
in second figure when i right click on it and do collapse all or expand all th size of the chart changes..which i dont want.
Hi,
Check now,
PFA
-Hirish
Hi hirish,
i want size of combination of all 3 columns and 2 columns should be same.
Hi,
May be try with 'Indent Mode' in Style Tab
Good suggestion.
I was going down the route of using macros on buttons ...
sub Expand
set obj = ActiveDocument.getsheetObject("CH02")
set objprop = obj.GetProperties
objprop.TableProperties.PivotAlwaysFullyExpanded = true
set objpropdims = objprop.Dimensions
objpropdims(0).ColWidth = 400
obj.SetProperties objprop
end sub
sub Collapse
set obj = ActiveDocument.getsheetObject("CH02")
set objprop = obj.GetProperties
objprop.TableProperties.PivotAlwaysFullyExpanded = false
set objpropdims = objprop.Dimensions
objpropdims(0).ColWidth = 700
obj.SetProperties objprop
end sub
.. or duplicating the pivot table and using conditional show to display the collapsed or expanded as desired.
flipside
Hi,
This way,
PFA,
Hirish