+ Reply to Thread
Results 1 to 8 of 8

Pivot table styling nuances

  1. #1
    Registered User
    Join Date
    12-25-2017
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    6

    Pivot table styling nuances

    Hi folks,

    I import data from third party APIs that have the data in a weird format where all the metrics are in columns and all the dimensions are in rows. Anyhow, I have to use the pivot tables. Sometimes.

    I'm trying to give them the layout of the rest of the document and I believe I did what I needed well enough except one thing. Here's my pivot table:

    4AwCch.jpg

    http://imagizer.imageshack.com/img923/7582/4AwCch.jpg

    Now, the question is how to make ONLY the two cells that have "Grand Total" to have white font color? You see, my first row and first columns are set to be white, but the total rows are set to be black. So the latter overrides the former and I need to reverse it. Can I?
    Last edited by Cthulchu; 12-30-2017 at 07:28 PM.

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    not-us
    MS-Off Ver
    PC: 5F / 61 / 7E0 (PQ/PP)
    Posts
    7,325

    Re: Pivot table styling nuances


    To attach an Excel file to your post,
    • desensitize data
    • remeber that your example should reflect structure and type of data
    • click Go Advanced,
    • scroll down until you see Manage Attachments,
    • click that and select Browse,
    • select your file and click Open,
    • click Upload and you will see your attachment below Upload Files from a website
    • click Close this window,
    • click Submit reply

    After that you should see attachment in your post
    sandy (NO CAPS)
    Excel can do everything but still doesn't read user's wishful thinking
    The ready made solution will not teach anyone anything

    A logical description of the problem is the basis of dialogue and a rapid solution. Nobody sits in your head to understand your way of thinking
    Note: English is not my native language
    Keep It Sophisticatedly Simple

  3. #3
    Registered User
    Join Date
    12-25-2017
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    6

    Re: Pivot table styling nuances

    I wasn't asking how to attach anything, but thanks.

    PS

    honestly, I'll start attaching empty excel files just to stop this useless offtopic.

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    not-us
    MS-Off Ver
    PC: 5F / 61 / 7E0 (PQ/PP)
    Posts
    7,325

    Re: Pivot table styling nuances

    Do you really need info: Pictures are of little value, attach sample excel file... etc?

    You choice
    have a nice day

  5. #5
    Registered User
    Join Date
    12-25-2017
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    6

    Re: Pivot table styling nuances

    I really do realize exactly how much value there's in the picture. If it's not enough for someone - don't answer the question. I won't blame. Thanks.

    I choice.
    cheers.

  6. #6
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Seattle, WA, USA
    MS-Off Ver
    MS Office 365 Excel 2016
    Posts
    13,426

    Re: Pivot table styling nuances

    Hi Cthulchu,

    It seems to me you would need to create a Pivot Color Scheme that does what you want. See:

    http://www.informit.com/articles/art...13215&seqNum=3
    One test is worth a thousand opinions.
    Click the * below to say thanks.

  7. #7
    Registered User
    Join Date
    12-25-2017
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    6

    Re: Pivot table styling nuances

    That's what I did. What I'm saying is that in that scheme Grand Total Row and Grand Total Column styles override the first column and first row styles as can be seen on the screenshot.

  8. #8
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Seattle, WA, USA
    MS-Off Ver
    MS Office 365 Excel 2016
    Posts
    13,426

    Re: Pivot table styling nuances

    Sorry then, I just have no idea..

+ 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