Maybe a macro would help with a more dynamic setting of rows and columns in the trellis chart ? e.g.
Set the number of columns to '3' but have a 'vCol' variable that sets a lower value if selections have reduced the number of columns =if(GetPossibleCount(country)<3,GetPossibleCount(country),3).
Set up a similar 'vRow' variable with another expression (depending on range expected).
then set up a macro, triggered OnActivate (for the sheet) and OnAnySelect (for the document) to do the following;
set chart = ActiveDocument.GetSheetObject("CH01")
set p = chart.GetProperties
That might give you the layout control you're looking for,
Although this is an old post, I would like to clarify your reply which is relevant to me right now.
I tried to use your Macro suggestion but it didn't work.
Attached my model, Can you please assist?
Trellis_Size_To_Data_1.qvw 141.8 K
Hi Ori Tal,
I was looking the file you sent and the macro works, only you have to configure the trigger on the document.
You should set the action in the variable in the Document Properties options
Attached the new file
Trellis_Size_To_Data_1.qvw 126.8 K
Hi abhinav garg,
I experimented with Trellis_type charts a while ago: You can set the nr. of rows and columns, given you have the screen_space to do it (if you have 3 values on that dimension, you get 3 charts, so it's better to display them in 1 row - so you need a lot of space horizontally - otherwise you'll have one of the four quarters of your charting_area blank...)
You can resize any part of the charts by clicking into the area once, then pressing Ctrl+Shift and dragging or resizing the field you want.