Need help formatting chart

[SpEdFriend]

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)

 

[Jon Peltier]

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

 

[SpEdFriend]

OK, I got that. Thanks. Where should I put the dates?

 

[Jon Peltier]

Dates? How do you want to show the dates?
- Jon

 

[SpEdFriend]

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]

Making an easy-to-read chart becomes an issue.

The way I suggested earlier works of a single day, or for an average over N
days.

An easy to read chart puts date in the first column, and A, S, and N in the
next three columns, where A, S, and N are either for a single food item or
for the average over all food items.

To get them into a single chart, you could put date into the first column,
food item into the second, and A, S, and N in the next three columns, and
plot all five columns. Put all rows for each date together, then delete all
but the first mention of the date, and the chart's X axis will be fairly
clear. It will not be easy to follow different food items from day to day

You might either consider sticking with multiple charts by day, one for each
food item, or one chart by day, averaging all food items.

Another approach is to use a single weighted number to represent A, S, and
N. Try something like A + 0.5 * S as a fraction positive. Then put dates in
the first column, and the (A + 0.5 * S) for each food item into another
column. Create a line chart, which will have this weighted ASN value vs.
time plotted with one line per food item.

- Jon