Chart Covering Info from Multiple Sheets

[OlYeller21]

I have survey data and each sheet holds the scores from a certain week for each of the 11 questions. I want to make 11 line charts that will show the answers over time for each question. For instance, chart 1 would be question 1. A week would be the x value of each point and the y value would be the average score for that question. The score is in the same cell on each sheet it that makes a difference. Any help would be greatly appreciated.
Zach

[Jon Peltier]

Check out this:

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

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


"OlYeller21" <[email protected]> wrote
in message news:[email protected]...
>
> I have survey data and each sheet holds the scores from a certain week
> for each of the 11 questions. I want to make 11 line charts that will
> show the answers over time for each question. For instance, chart 1
> would be question 1. A week would be the x value of each point and the
> y value would be the average score for that question. The score is in
> the same cell on each sheet it that makes a difference. Any help would
> be greatly appreciated.
> Zach
>
>
> --
> OlYeller21
> ------------------------------------------------------------------------
> OlYeller21's Profile:
> http://www.excelforum.com/member.php...o&userid=36309
> View this thread: http://www.excelforum.com/showthread...hreadid=562836
>