Hello again!
I have a dynamic chart based on a named range. It displays the percentage of the subject (specific column) of all papers (each is a line) listed on the range, named "main_tab". If it matters the "main_tab" range is also "dynamic" (not a fix range, but uses OFFSET and COUNTA formulas). Also for the records, the subjects have data validation input based on a list wich is also dynamic (OFFSET+COUNTA)...
When you input data and refresh, the chart does its work finely, but only if you respect the pre-existing subjects. If you make an entrance with a new subject (of course adding it first on the reference list) it totally ignores it. The dynamic chart doesn't display the new subject, neither in the pie or the subtitles, and I need to create a new chart everytime a new subject is added.
Any tips? Am I missing something?
I have a dynamic chart based on a named range. It displays the percentage of the subject (specific column) of all papers (each is a line) listed on the range, named "main_tab". If it matters the "main_tab" range is also "dynamic" (not a fix range, but uses OFFSET and COUNTA formulas). Also for the records, the subjects have data validation input based on a list wich is also dynamic (OFFSET+COUNTA)...
When you input data and refresh, the chart does its work finely, but only if you respect the pre-existing subjects. If you make an entrance with a new subject (of course adding it first on the reference list) it totally ignores it. The dynamic chart doesn't display the new subject, neither in the pie or the subtitles, and I need to create a new chart everytime a new subject is added.
Any tips? Am I missing something?
