Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Need help with Sunburst chart and making second layer of data overlap different slices of first layer, for example, if first layer was male and female names, and second layer was "male" or "female", male would cover all male names and female would cover all female names
Solved by X. J. in 31 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 01/08/2018 - 08:10
Hi
User 01/08/2018 - 08:10
Hi
Excelchat Expert 01/08/2018 - 08:10
If I understand your problem correctly, you have a dataset from which you want to create a sunburst chart
Excelchat Expert 01/08/2018 - 08:10
Is that correct?
User 01/08/2018 - 08:11
Yes
User 01/08/2018 - 08:11
But I need the second layer to cover multiple items on the first layer
Excelchat Expert 01/08/2018 - 08:11
First, can you share the dataset?
User 01/08/2018 - 08:11
See it?
Excelchat Expert 01/08/2018 - 08:12
Here, what should be the first layer and what should be second layer?
User 01/08/2018 - 08:12
Column 1 firstlayer
User 01/08/2018 - 08:12
Column 3 second layer
Excelchat Expert 01/08/2018 - 08:13
And what about column 2?
User 01/08/2018 - 08:13
There is no column 2
User 01/08/2018 - 08:13
They are names
User 01/08/2018 - 08:13
*named
Excelchat Expert 01/08/2018 - 08:13
Ok, so what about blank rows?
User 01/08/2018 - 08:14
C3 applies to B3 and B4
User 01/08/2018 - 08:15
Make sense or no?
User 01/08/2018 - 08:15
401(k) is ordinary income and cash is also ordinary income
Excelchat Expert 01/08/2018 - 08:15
Got it
Excelchat Expert 01/08/2018 - 08:15
Give me some time
User 01/08/2018 - 08:26
What happens when our timer runs out?
Excelchat Expert 01/08/2018 - 08:26
Hey, you will get an option to extend it
Excelchat Expert 01/08/2018 - 08:26
please do so
User 01/08/2018 - 08:27
Done
Excelchat Expert 01/08/2018 - 08:28
Awesome
Excelchat Expert 01/08/2018 - 08:28
Please see if this is what you want
[Uploaded an Excel file]
Excelchat Expert 01/08/2018 - 08:28
I took liberty to use 100k instead of 1M in one of the rows. You can change the value to whatever you want :)
User 01/08/2018 - 08:29
It's good, but it's reversed.
User 01/08/2018 - 08:29
I want 401k and cash and NQ and real estate in the center
Excelchat Expert 01/08/2018 - 08:34
Hey, I have double checked and made sure that it is not possible. The inner values will always be the bigger ones and the partition in the outer rings.
Excelchat Expert 01/08/2018 - 08:34
If you want what you are suggesting some other techonlogies like D3 should be useful
User 01/08/2018 - 08:34
That makes no sense
User 01/08/2018 - 08:34
D3?
Excelchat Expert 01/08/2018 - 08:35
Yes, if you interchange your columns it doesn't make sense
Excelchat Expert 01/08/2018 - 08:35
Since ordinary is bifurcated to 401(k) and Cash
Excelchat Expert 01/08/2018 - 08:36
D3 is javascript based visual tool
Excelchat Expert 01/08/2018 - 08:36
Yes, that's the limitation of excel
User 01/08/2018 - 08:36
Why can't ordinary be a second layer that covers both 401k and cash?
Excelchat Expert 01/08/2018 - 08:36
That is the limitation of Excel
User 01/08/2018 - 08:36
Bummer
Excelchat Expert 01/08/2018 - 08:37
haha yes. Though excel has incorporated new charts, the capabilities are still not full on
Excelchat Expert 01/08/2018 - 08:38
Why would you want them specifically in the second layer?
User 01/08/2018 - 08:38
That's the order of the conversation I have with my clients
User 01/08/2018 - 08:38
:)
User 01/08/2018 - 08:38
I can make it work though
User 01/08/2018 - 08:38
Thank you!
User 01/08/2018 - 08:39
Do you know if it's possible to add a center circle with text?
User 01/08/2018 - 08:39
From the table
Excelchat Expert 01/08/2018 - 08:39
I would rather add a Circle shape in between to achieve that. It is not technically possible
User 01/08/2018 - 08:40
Gotcha, thanks
User 01/08/2018 - 08:40
I think we are done
Excelchat Expert 01/08/2018 - 08:40
I hope I was helpful
User 01/08/2018 - 08:40
Very
Excelchat Expert 01/08/2018 - 08:40
Have a great day :D
User 01/08/2018 - 08:40
You too

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.