Charts
 

hi, i have data on different sheets in a workbook. the data on the
first sheet is a name corresponding to which there is an amount in the
next cell. On the second sheet too, the same name appears but with a
different amount next to it. Is it possible to create a graph based on
the two values.

Charts
 

what kind of graph do you want to make?
to get the data together, Use an empty column next to the data in the first
sheet,
if names are in A and Data in B and column C were empty,
in C1 enter
=if(iserror(Vlookup(A1,"Sheet2'!A:B,2,0)),"",Vlook up(A1,"Sheet2'!A:B,2,0))
copy down
now you will have the data side by side

"tc" wrote:

hi, i have data on different sheets in a workbook. the data on the
first sheet is a name corresponding to which there is an amount in the
next cell. On the second sheet too, the same name appears but with a
different amount next to it. Is it possible to create a graph based on
the two values.