Sunburst diagram with dynamic, named range.

Question

Hi,&nbsp;I have a sunburst diagram with a named dynamic range which works perfect. Until I save it, and reopen. The 2 of the "rings" are gone.&nbsp;How it should look like:&nbsp;When I open the file again:&nbsp;&nbsp;I attach a simple Example file.&nbsp;Best regards- Geir

sergeibaklan · Answer

Hogstad_Raadgivning&nbsp;
Geir, I can't reproduce. Re-open saved file; changed Person 2 on Person 1 and re-open again, etc - it works. I'm on latest for today Beta.

hogstad_raadgivning · Answer

Thank you,&nbsp;SergeiBaklan&nbsp;&nbsp;I redesigned it a bit. and now using the table for data inpunt. Not a named range. Except for the sort/size column.&nbsp;I cab choose "Ordinær år" or "Fy år" Ordinært år is OK. But i do not understand wy the diagram shows wrong order using FY år.&nbsp;The selection:&nbsp;The sort/size range&nbsp;&nbsp;The named range used in the diagram:&nbsp;A copy is attached.&nbsp;Best Regards- Geir

hogstad_raadgivning · Answer

I suddenly got it... table must be sorted by the same values as the dynamic array I combine with.Case closed/Geir

Forum Discussion

Sunburst diagram with dynamic, named range.

3 Replies

Resources