+ Reply to Thread
Results 1 to 6 of 6

Sunburst Chart Color Issue

  1. #1
    Registered User
    Join Date
    02-11-2019
    Location
    Overland Park, Kansas
    MS-Off Ver
    2016
    Posts
    5

    Sunburst Chart Color Issue

    I'm using Excel 2016. Has anyone encountered issues when trying to change the colors in a sunburst chart? There are 4 rings. There is one area on the 2nd outer most ring that I can't seem to isolate to change its color. I have another area on the outer most ring that is green, but when selected is yellow. I want it to stay yellow.

    Thanks,
    Chris

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Sunburst Chart Color Issue

    Right click on the chart, Format Plot Area, Click on the down arrow next to Plot Area Options, then see if you can select the rings from there to change the color.

  3. #3
    Registered User
    Join Date
    02-11-2019
    Location
    Overland Park, Kansas
    MS-Off Ver
    2016
    Posts
    5

    Re: Sunburst Chart Color Issue

    I can't see how to select individual rings.

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Sunburst Chart Color Issue

    I'm not sure that you can or cannot as I have not used one myself but if you upload a small representative sample of your data and chart, we can take a look.

    To upload an Excel workbook, follow these steps:
    1) Click on "Go Advanced"
    2) Click on "Manage Attachments"
    3) Click on "Choose File"
    4) Choose your file and click on "Open"
    5) Click on "Upload"
    6) Click on "Close this window"

  5. #5
    Registered User
    Join Date
    02-11-2019
    Location
    Overland Park, Kansas
    MS-Off Ver
    2016
    Posts
    5

    Re: Sunburst Chart Color Issue

    Example file attached.

    Thanks,
    Chris
    Attached Files Attached Files

  6. #6
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Sunburst Chart Color Issue

    Ran out of time. Will have to come back to this.

    One thing that I noticed is that all other sunburst charts that I've seen have the same color going out from the center instead of in rings.

+ 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. Sunburst - Dynamic Range
    By ionelz in forum Excel General
    Replies: 2
    Last Post: 01-24-2019, 04:02 AM
  2. Sunburst Chart Excel 2016
    By whatsherface1990 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-08-2018, 07:06 PM
  3. How to hide rows without making Sunburst chart to disappear
    By Ravichandran Kannapp in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-14-2017, 05:40 PM
  4. [SOLVED] How to reverse Sunburst chart Clockways
    By sovietchild in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-16-2016, 04:18 AM
  5. Replies: 4
    Last Post: 01-12-2016, 05:07 PM
  6. Pie Chart color shading issue
    By super_duper_guy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-19-2011, 12:29 AM
  7. Infuriating VB Excel chart issue - how to change y axis font color
    By Ace of Clubs in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-07-2009, 01:22 AM

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