Chart cell data from multiple worksheets

  • Thread starter Thread starter paul
  • Start date Start date
P

paul

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

Thanks.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Abstracting Error Bar Data From Charts 3
Chart data references not changing to new tab when worksheet is co 1
Charting multiple worksheets 2
Multiple charts from 1 source data 2
Create multiple Charts from one worksheet 2
Link a chart to a worksheet 1
Auto update the chart range for new sheets 2
Custom error bars bug -- copy pasting chart does not update refere 5

Back
Top