See my other reply. You need to make yourself a summary range on one of
your worksheets, or on a new summary sheet, link these cells with
formulas to the individual sheets' data (Copy - Paste Special - Links
does this nicely), and make your chart from the summary range.
