7 Replies Latest reply on Feb 4, 2019 1:23 PM by Peter Fakan

    Dynamically resize sheets on a dashboard

    Lisa Viale

      Hi,

      I have a dashboard that includes 3 sheets. I would like to fix the size of one sheet, and let the other two expand and contract depending upon the data. For the sheets that are resized, I need to have the font and spacing remain consistent.I would like the size of the page to increase if the data gets too large.

      What I am finding is that for larger data sets, the rows become squished. For smaller data sets, the spacing of the rows increases.

      I have tried to set the layout to both Automatic, and a Range. The Range option seems to have a max height regardless of the number that I enter.

       

      I've uploaded a sample workbook. The top sheet is fixed, the bottom two should adjust. However, if I filter on Consumer Discretionary, the rows are too compressed.

      Thanks