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

I moved this here because I wasn't getting any replies in the chart
section.


--
OlYeller21
------------------------------------------------------------------------
OlYeller21's Profile: http://www.excelforum.com/member.php...o&userid=36309
View this thread: http://www.excelforum.com/showthread...hreadid=562976

Check out Jon Peltier's site. He wrote up instructions for charting data
from different sheets:


http://www.peltiertech.com/Excel/Cha...entSheets.html

Michael Behm
"OlYeller21" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>
> 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
>
> I moved this here because I wasn't getting any replies in the chart
> section.
>
>
> --
> OlYeller21
> ------------------------------------------------------------------------
> OlYeller21's Profile:
> http://www.excelforum.com/member.php...o&userid=36309
> View this thread: http://www.excelforum.com/showthread...hreadid=562976
>