+ Reply to Thread
Results 1 to 2 of 2

Donut Chart with 2 data sets - Legend does not work

  1. #1
    Registered User
    Join Date
    06-26-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2007
    Posts
    28

    Donut Chart with 2 data sets - Legend does not work

    Hello guys,

    Trying to put a 2 layer donut chart together but have the problem my legend does not work. I have assets on the inside donut and liabilities on the outside donut. The issue I am facing is that my legend will only show the inside donut dimensions and not the outside donut dimensions. Have attached my example if someone could PLEASE help.

    Thanks,
    Jay.
    Attached Files Attached Files

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Donut Chart with 2 data sets - Legend does not work

    Hello,

    I don't think you can have different categories in the inside and outside rings. The idea of a multi-ring donut is to compare the same categories with sets of different values. That's why the legend only shows the categories of the first data set.

    In any case, with that many data points, a donut or a pie are not the best visualisation. If you want glitz, fine. But if you want a useful chart, go for columns or bars.

    Create one column or bar chart for Assets and another for Liabilities and put them side by side. That way, your reader can quickly eyeball each individual item's size. A donut wedge is much harder to judge and comparing the size of the first item on the outer ring with the sixth item of the inner ring will be near impossible.

    Donuts are for people who don't understand good data visualisation.

    cheers, teylyn

+ 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. Rotate data labels in Donut chart in 18Oo
    By beneesetas14 in forum Excel General
    Replies: 6
    Last Post: 04-30-2015, 06:34 AM
  2. [SOLVED] Recreate this donut chart?
    By IronCladRooster in forum Excel General
    Replies: 2
    Last Post: 12-16-2014, 03:44 PM
  3. [SOLVED] Adding sets of data from different work sheets into a third work sheet.
    By leele2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-12-2013, 01:59 AM
  4. Replies: 2
    Last Post: 04-15-2013, 08:50 AM
  5. how to make a Donut Chart
    By mushman1 in forum Excel General
    Replies: 4
    Last Post: 06-22-2010, 04:54 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