Chart linked cells?
 

I have a summary sheet where the cells are automatically updated. I cannot
create a chart with that information. The value is shown as zero when table
data is checked.