Please post a sample workbook (with all sensitive data removed), showing where is the data being input, and with that chart.

Also, by what you described, do you also mean that the chart's source data should dynamically change as well?