Need help formatting chart
 

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)

Need help formatting chart
 

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)

Need help formatting chart
 

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)

Need help formatting chart
 

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)

Need help formatting chart
 

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)

Need help formatting chart
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"SpEdFriend" wrote in message
...
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)