Dynamic Ranges for charts

[BittenApple]

Hello team,

I have data, I need to insert a chart for this data. This data is dynamic, which is based on a selection of dropdown menus; so the range changes.

I thought if I convert the data to a table, that resolves my problem; but when I convert my data to a range, all the values from formulas disappear.

Should I convert the series ranges to a dynamic range? If yes, how can I get to that point?

Regards,

[HansV]

Have you tried recreating the formulas?

[BittenApple]

Not yet.
Let me do it.

Respectfully,
Bita

[BittenApple]

I was able to figure out.
Thanks

[BittenApple]