Excel Charts not recognizing data changes

[Mick36]

I have a file that is serving as a template for an analysis. I want to import data and then have histograms reflecting results of the data. I have made a vba that imports the data to the correct locations, and histograms preset to specified cells with formulas. After the data is imported, everything is in the correct location and all of the cell values arw correct. But, the chart is still empty. I have to manually click on each chart and select data to refresh the charts to display the values in the cells that they are referencing. I do not understand why this happens or how to fix this. I have turned on every setting I can think of before and after the data import vba runs to no success. I also am unable to recreate this in a new excel file so i am very confused. Any suggestions are greatly appreciated.