Cross referencing data from one worksheet to another

[jlmckaymount]

Hi

I have all my raw data on worksheet one and in that I need to cross
reference various peoples names against the various states of
customers. So I need to seperate the 6 names against the 5 states of
customers and produce a figure for each. Can anyone advise?

thanks
James

 

[Joel]

You need to build a new table for each chart. the new tables can reference
cells in the old table by using =Sheet1!A5