PIVOT - EXCEL tables - color
On Sheet2 the lines are grey and on Sheet4 the lines are black. Is it possible to make the lines default black in Excel 2016, just like they were in Excel 2010?
Attachment explanation:
Sheet1: Pivot from Excel 2016
Sheet2: Copied table from Sheet1
Sheet3: Pivot from Excel 2010
Sheet4: Copied table from Sheet3
Last edited by phjervild; 08-13-2020 at 01:48 AM.
HOW TO ATTACH YOUR SAMPLE WORKBOOK:
Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
I will look at it after your update (a small part) of the file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
It should now be updated with an Excel sheet - Thank you! :-)
in sheet 3 you have a pivot table, linked to extern data.
in that sheet you can choose the format of the pivot table.
tab 12 => Lay Out (if you stand in your pivot table).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks