Linear chart from cells in multiple worksheets

[Spyder]

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!!

 

[Jon Peltier]

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 here:

http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html

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