+ 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
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,750

    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
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  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
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,750

    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,809

    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,809

    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