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

[amit_saini]

Hi,

Check if this helps u:

https://community.qlik.com/message/111528#111528

Thanks,

AS

[saumyashah90]

yeah thats what i wanted but the solution doesnt work the way answered.

[jonathandienst]

Uncheck the "Size to Data" check box on Chart Properties | Presentation.

EDIT: oops, that should be Properties | Layout (Thanks amit)

[amit_saini]

Hi Jonathan,

I think it's here on Layout tab:

Thanks,

AS

[Anonymous]

After selecting Always Fully Expanded, you have to adjust the column width, see the attached

[saumyashah90]

I guess its in Layout.

Its already unchecked

[amit_saini]

Saumya,

For sure you need to adjust columns size here, I don't think any automation will work here

Thanks

AS

[HirisH_V7]

Hi,

Check this way -> properties -> layout -> options -> Size to Data.

PFA,

HTH,

Hirish

[saumyashah90]

Hi Hirish,

After doing expand all your chart width gets increased.Which i dont want