Linear chart from cells in multiple worksheets

How can I build a chart that pulls the text entry from one cell and the
numeric entry from another cell from multiple sheets within the same
workbook? These will be the same two cell locations on all the worksheets.
Each worksheet will be used to generate a score for an indivdual that appears
in the text cell. I would like to see the scores plotted on a 1 dimensional
horizontal axis with the corresponding name below each point.

Thank you for any help!!

All the data for a series has to come from the same worksheet, but you
can use formulas to bring it all together onto a single summary sheet. I
give one method he

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

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

Spyder wrote:

How can I build a chart that pulls the text entry from one cell and the
numeric entry from another cell from multiple sheets within the same
workbook? These will be the same two cell locations on all the worksheets.
Each worksheet will be used to generate a score for an indivdual that appears
in the text cell. I would like to see the scores plotted on a 1 dimensional
horizontal axis with the corresponding name below each point.

Thank you for any help!!