update chart to handle missing data