Chart cell data from multiple worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

paul - 23 Dec 2003 16:25 GMT

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

Thanks.

Reply to this Message

Jon Peltier - 23 Dec 2003 17:34 GMT

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
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

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

Reply to this Message