I want same size of the chart and expression column

[saumyashah90]

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

[saumyashah90]

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.

[HirisH_V7]

Hi,

Check now,

PFA

-Hirish

[saumyashah90]

Hi hirish,

i want size of combination of all 3 columns and 2 columns should be same.

[settu_periasamy · Accepted solution]

Hi,

May be try with 'Indent Mode' in Style Tab

[flipside]

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

[HirisH_V7]

Hi,

This way,

PFA,

Hirish