Linear chart from cells in multiple worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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