+ Reply to Thread
Results 1 to 4 of 4

Pivot Table Rounded Corners?

  1. #1
    Registered User
    Join Date
    02-12-2019
    Location
    new york
    MS-Off Ver
    office 365 proplus 1811
    Posts
    13

    Unhappy Pivot Table Rounded Corners?

    Hello All,

    I'm building an interactive dashboard in Excel.

    When I went online to learn tips and tricks how to build it, I came across a Microsoft article explaining how to build a simple dashboard.

    However, I can create all of the content included in the dashboard except the tables with the rounded corners.

    Is there a formatting way to create the Pivot tables (or any table type for that matter) wit the rounded corners automatically? I am trying to avoid the use of Macro's.


    I would really appreciate all input on this matter.

    Thanks!
    Attached Images Attached Images

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Pivot Table Rounded Corners?

    It's just optical illusion

    Pivot tables are created as normal. Then worksheet's Gridlines are removed (in View -> Show, uncheck gridlines).

    And then multiple shapes are added to give visual effect and buttons and headers are removed from Pivot Table(s).

    See quick mock-up attached. Personally, I'm not a fan of this approach.
    Attached Files Attached Files
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    02-12-2019
    Location
    new york
    MS-Off Ver
    office 365 proplus 1811
    Posts
    13

    Re: Pivot Table Rounded Corners?

    CK76 - Id marry you if I could.

    Thank you. This entire time I thought it was a simple formatting.

    Have a good day

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Pivot Table Rounded Corners?

    You are welcome and thanks for the rep

+ 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. Can't Drag Corners
    By andrealight1 in forum Excel General
    Replies: 1
    Last Post: 11-07-2014, 06:59 AM
  2. syntax for comparing a rounded number to a rounded list
    By stockgoblin42 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-10-2013, 10:12 AM
  3. [SOLVED] Green corners
    By dcwm in forum Excel General
    Replies: 2
    Last Post: 12-29-2012, 10:37 AM
  4. Sparkline chart not reflecting rounded values from pivot table
    By Paul-NYS in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-09-2012, 11:22 AM
  5. Ticks in the cell corners
    By oldron34 in forum Excel General
    Replies: 1
    Last Post: 07-11-2007, 03:20 PM
  6. Rectangle with curved corners
    By Zone in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-03-2006, 02:40 PM
  7. rounded corners in charts not in newer Excel version
    By jeffreyfarrell in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-31-2005, 10:20 PM

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