Creating a chart using data from multiple sheets

Hi Guys,

I'll pre-empt this by saying that I've never really used Excel for much apart from just recording very simple data, and so the following is quite a leap for me so please be gentle

I have a workbook to help me track of the ranking of a website. The workbook contains several sheets, and basically the data looks a bit like this:

HTML Code: 

Although the existing info is useful, what I would like to be able to do is display the info via a chart so that it's visually easier to pic out any trends.

Would someone be able to point me in the right direction to get me started? Is it possible to create charts across multiple workbooks?

There is also a slight complication in that from time to time I add / remove search terms from the results.... as a result, the cell position of a search term may differ from sheet to sheet.

As a result, I guess I need to do something which says: "look for this search term in each sheet, then compare the data, and render in a graph" as opposed to saying "go to cell B7 in each sheet"... as that might display the wrong data - hope that makes sense?)

Any help would be really, really appreciated!

Thanks!
Kessa

Sorry - I forgot to say that I'm using Excel 2007 and 2003

create a new worksheet, and pull in your data to it. Then create whatever chart you fancy


in A1 of new sheet, =sheet1!c3

will return whatver is in cell c3 of sheet 1

Hi Robert,

So if I need to get it to check across multiple sheets how would I do that? Would I need to do something like:

=sheet1!c3/sheet2!c3/sheet3!c3

(sorry - I don't know what the correct syntax is to list sheets so I've just used "/" above but you get the idea)

Also, how do I get it to do this by matching up the search terms as (as mentioned in my original post) these aren't always in the same place so I need to be able to dynamically locate them without having to manually point to each term each time.

Thanks