Each day, I have the student indicate food choices prior to eating lunch.
When the food choices are provided as lunch, I chart whether the kid ate the
food or not (the A, S, or N) What I need to show is progress (or lack of
progress) over time. For example, in the beginning she chose a hamburger, but
did not eat it, and had a tantrum when she saw that someone else had a
burrito, which turned out to be what she really wanted. After a couple times
of doing that, she figured out that the choices she makes will actually show
up at lunch :-) Now, she chooses burritos often. I need to show this
progress, and without the dates I have good info about choices, but it does
not show the evolution toward accurate choices.
Your previous suggestion was super, I was able to make very clear charts
following that will be very helpful for families. (I actually have several
students making various choices that we are tracking)
Thanks in advance for all your help.
SpEdFriend (Val)

"Jon Peltier" wrote:

Dates? How do you want to show the dates?
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"SpEdFriend" wrote in message
...
OK, I got that. Thanks. Where should I put the dates?


"Jon Peltier" wrote:

Put food names in the first column of the data, the values for All in the
second column, for Some in the third column, and for None in the fourth.
Select the data and create a stacked column chart with series in columns.

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


"SpEdFriend" wrote in message
...
I am trying to make a chart to show the accuracy of food choices made my
significantly disabled student. The worksheet I made has food choice
names,
the data collection dates, and then notations of whether the student
ate
all
(a) some (s) or none (n) of the food after choosing.
How do I get a chart that will show the a,s and n values as different
colors
in a stacked bar? (at least that's what I think I am looking for, but
would
be happy with any clearly readable chart)