Forum Discussion
Sunburst diagram with dynamic, named range.
Hi, 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. How it should look like: When I open the fi...
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.
Thank you, SergeiBaklan
I redesigned it a bit. and now using the table for data inpunt. Not a named range. Except for the sort/size column.
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.
The selection:
The sort/size range
The named range used in the diagram:
A copy is attached.
Best Regards
- Geir
- I suddenly got it... table must be sorted by the same values as the dynamic array I combine with.
Case closed
/Geir