+ Reply to Thread
Results 1 to 2 of 2

Dashboard background cell colouring removed by pivot when resized smaller

  1. #1
    Registered User
    Join Date
    05-07-2013
    Location
    Reading, England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Dashboard background cell colouring removed by pivot when resized smaller

    I have a dashboard with graphs (January to December) and the supporting Pivot data displayed below (with Months reading across in columns left to right) - 13 columns in all (Field Title + 12 months). Says Cells A1:M2.
    I have coloured grey the cells of the dashboard not taken up by Pivots/graphs.

    However, when I dynamically change the Pivots to just display less than 12 months of data ...and the Pivot compacts the number of columns (eg for just January, the pivot only needs Cells A1:B2)- the column cells vacated by the Pivot (Cells C1:M2) just go white. The old grey dashboard colouring is removed.

    How can I keep this, regardless of how the pivot resizes itself according to the scope of data selected in timeline/filters?

    Thanks.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Dashboard background cell colouring removed by pivot when resized smaller

    apply conditional format specifically to charts

    http://www.contextures.com/excelpivo...nalformat.html
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot Table Background Cell Color
    By nms2130 in forum Excel General
    Replies: 5
    Last Post: 02-02-2017, 07:12 AM
  2. [SOLVED] Dashboard in Background [DATABASE ERROR]
    By sophiemac in forum Excel General
    Replies: 7
    Last Post: 05-24-2016, 03:51 PM
  3. [SOLVED] Entries on pivot table removed when table cell = 0
    By lockers in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-23-2014, 12:29 AM
  4. [SOLVED] Colouring of pivot table
    By Villalobos in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-15-2014, 09:29 AM
  5. Different colouring in a pivot table
    By swchoi89 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-17-2014, 10:48 AM
  6. Replies: 2
    Last Post: 03-29-2012, 12:42 PM
  7. I need a more flexible and smaller background
    By tomkorver in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-08-2009, 09:48 AM

Tags for this Thread

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