Sunburst with dynamic title

[anderma8]

I have a sunburst that adjusts to two drop downs. I am trying to make the title reflective of the users selections to give further clarity to what the chart presents but I can't seem to get the title to accept a cell reference. Might anyone know if this is a limitation or am I just not doing it correctly?

 

[C Moore]

Can you not select the picture, click the formula bar then =cell?

 

[anderma8]

I can select the sunburst. I can add a title. In the title section, I'm expecting to be able to put "=" and select a cell that has the dynamic title, but it won't let me select the cell.

 

[C Moore]

 

[Fluff]

Whilst I know nothing about charts, it appears that you cannot use a formula for the title on a sunburst chart.
However you could put a shape covering the title & use that instead.

 

[anderma8]

Whilst I know nothing about charts, it appears that you cannot use a formula for the title on a sunburst chart.
However you could put a shape covering the title & use that instead.

Thank you for your suggestion - I think I'll use that in place of a title to the graphic!! Thank you - I would not have thought of that solution!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[cradenborg]

Whilst I know nothing about charts, it appears that you cannot use a formula for the title on a sunburst chart.
However you could put a shape covering the title & use that instead.

The issue of this solution is that you can't save the diagram as jpg including the title. It doesn't seem possible to include a object in the diagram as with other diagrams as well.