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

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

Guest

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."
 
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.
 
Back
Top