http://peltiertech.com/Excel/ChartsH...iffSheets.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"tc" wrote in message
oups.com...
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.