›

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Quick Links

Categories

how to make allocation pivot larger

jwengajwenga
in Excel Workbook
I have 8-9 allocations that I track but I can not see all of them in the chart when I view all my accounts. Is there a way to add lines or make the pivot larger. I realize this is probably an easy task but I'm not finding a solution. TIA


Comments

  • VidasMatelisVidasMatelis
    On the right side (far right) there are 4 reports that prevent you from inserting cells. They are in columns S to AC.
    Select area with these reprots (Area R1 to AC21) and CTRL+X (cut) then select cell in area S25 and do CTRL+V (paste).
    Select ROW 19, right mouse click and then choose "Insert". Do this couple times till you have enough space for your report.
    Optionally you can move back these 4 reports from S25 to top (not necessary).
  • jwengajwenga
    I followed your directions but still getting this error when trying to insert lines at ROW 19


  • VidasMatelisVidasMatelis
    Likely you have error as you already have something in line 18/19.
    Extra step: In your allocation report select icon on the right of Allocation


    Then select Value filter, TOP 10 and change it to be top 5. Apply changes. Confirm there is nothing in line 19 and then try doing "Insert" row.
  • jwengajwenga
    all good now. Thank you sir!
Sign In or Register to comment.