Tip:
Highlight text to annotate it
X
for those who want to
download the worksheet in these next examples
go to the frugalcomputerguy.com video tutorials
and then office spreadsheet and down at the bottom that page
I will add the link to download those
ods spreadsheets. in this example
we have our rating of the favorite appetizers main dishes and desserts
are three categories here and we've got subgroups I guess is what we call that
so to do that kind of chart
want to get there rating in there as well
and I will change this to
a bar chart because I think it looks a little
nice there and clicking finish
if I make this little longer
we should have all the the values showning
in our groups - we see the deserts main dishes and appetizers
one other thing I wanted to show you was instead of going
into the charting tool if we just
type in equals repeat and then we're going to say
bar.... we are going to give it
this bar and then we say
for the value of D4
it gives us a little...
our own little bar chart there and I'm
copying and pasting using and control+C control+V
and its kinda quick little way to give you an idea of
a bar chart without actually using the charting tool at all
all
all cool