Chart to Automatically Update with new data that is pulled through to a table

[jpwilkinson14]

So I have a survey which is being sent out to multiple people (up to 26).

The data for each person is plotted in a chart to show their scores but i need the chart to update automatically every time new data is added.

The issue is, I have a master set of data were the input is put into, but then have a secondary set of data which pulls the relevant data through for each chart.

This secondary set of data uses formula to pull through data from the master set, and if there is no relevant data for the new row, then the formula tells it so show a blank.

i think the table is not expanding as the cells below the table have formula in and when they turn from blank to having values, the table does not expand into it.

For example

Responder
A 15
B 25
C 18 --- table currently goes up to here and chart data is pointed to these three
D =if(masterdata F5="","", 26)

So when there is no response from person D in the master set, the chart correctly displays ABC, but when values appear in the masterdata, the values pull through to my secondary table, but the table doesnt expand at the chart does not update.



Is there a solution for this (preferably not VBA).