+ Reply to Thread
Results 1 to 3 of 3

Sunburst Chart Excel 2016

  1. #1
    Registered User
    Join Date
    01-05-2018
    Location
    New York, USA
    MS-Off Ver
    2016
    Posts
    2

    Post Sunburst Chart Excel 2016

    Hi Everyone,

    I am creating a sunburst chart on Excel (Automatically) but having some trouble with 2 things:

    1) In the legend, the axis labels with no data in the series have no color - I want the legend to show a color for those points even though they don't have data and they won't show in the chart.

    2) Is there anyway to manually edit the colors of the different data markers of the same series data in the chart?

    Would appreciate anyones help! Thank you !!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,438

    Re: Sunburst Chart Excel 2016

    Looks like the only way to get the series to have a colour in the legend is for the data point to have a positive non zero value.
    Try giving the data point a very small value.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-05-2018
    Location
    New York, USA
    MS-Off Ver
    2016
    Posts
    2

    Re: Sunburst Chart Excel 2016

    Thank you!!

+ 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. 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
  2. Box & Whisker chart from VBA Excel 2016
    By cliftonvilla in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-21-2017, 03:25 AM
  3. Replies: 1
    Last Post: 09-18-2017, 08:27 AM
  4. Excel 2016 Bar chart with Total and Count
    By milindsaraswala in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-05-2016, 01:35 AM
  5. [SOLVED] How to reverse Sunburst chart Clockways
    By sovietchild in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-16-2016, 04:18 AM
  6. [SOLVED] Excel 2016 getting Freeze during inserting chart
    By anu0512 in forum Excel General
    Replies: 5
    Last Post: 04-18-2016, 08:07 AM
  7. Excel 2016 - how to omit missing dates from chart
    By no-sweat in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-20-2016, 12:44 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