+ Reply to Thread
Results 1 to 2 of 2

2 Panes, Different Scale - 1 Heading Section Above, 1 Pivot Table Section Below

  1. #1
    Registered User
    Join Date
    06-12-2013
    Location
    Aus
    MS-Off Ver
    Excel 2010
    Posts
    2

    2 Panes, Different Scale - 1 Heading Section Above, 1 Pivot Table Section Below

    I have a daily report format as shown in the first picture.

    The heading fits the width of the page when there are 6 value columns, however this will change constantly day today. This leads to the heading shrinking as shown in picture two if there are more than 6 (or the pivot table not reaching page edge if there are less)

    Is there a way to scale the pivot table below and keep the heading a constant size?

    I am sure this would be useful for others who are also looking to build a professional looking form around a pivot table with an unfixed width.

    Really look forward to any feedback as this has been bugging me for a while. New Bitmap Image.jpg 2.jpg

  2. #2
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    Re: 2 Panes, Different Scale - 1 Heading Section Above, 1 Pivot Table Section Below

    Cross posted here:

    http://www.mrexcel.com/forum/excel-q...ion-below.html
    If I've been of help, please hit the star

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1