Chart cell data from multiple worksheets

[paul]

How do I create a bar graph using cell data from multiple
worksheets?

Thanks.

 

[Jon Peltier]

Paul -

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.

- Jon