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,
Dynamic Ranges for charts
-
- Administrator
- Posts: 78499
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Dynamic Ranges for charts
Not yet.
Let me do it.
Respectfully,
Bita
Let me do it.
Respectfully,
Bita
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Dynamic Ranges for charts
I was able to figure out.
Thanks
Thanks