How do I add data from different sheets to a chart?

[SWeyer]

I am trying to make a chart that tracks the average of a quality assessment
monthly. Basically I have 12 worksheets, one for each month. The average
grade (1-5) for each month is calculated in the same cell on each sheet. How
do I get a line chart to display this value from each worksheet on the same
chart, with month as the X axis and the value as the Y axis? I am having
trouble with the "syntax."

 

[Barb Reinhardt]

The lookup functions might work for this application. Without being able to
visualize what you want to do, it makes it difficult to give a suggestion.

 

[Jon Peltier]

I have a brief explanation here:

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

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