Dynamic Chart ignores new input

JCamara

New Member
Joined
Jan 14, 2015
Messages
38
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?
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

JCamara

New Member
Joined
Jan 14, 2015
Messages
38
bump. can someone please help me? I bet is a simple thing that i'm missing.

Otherwise I'll have to hardcode a macro that recreates the charts :(

Thnx in advance!
 

Watch MrExcel Video

Forum statistics

Threads
1,108,677
Messages
5,524,230
Members
409,566
Latest member
santoshsj

This Week's Hot Topics

Top