in this video tutorial
we're going to continue looking into the
chart
feature of LibreOffice Calc for this
tutorial we've got sample data from a
restaurant
we've got three meals steak pasta and
vegetarian
and three stores - store 1 store 2 and store 3
we have grouped by the number sold
on a particular night and then the
amount of income from that number sold
based
on the selling price.  I'm going to create a chart
by selecting the meals
and the stores and the
the number sold and 
clicking and the chart.  this
is showing us that
its group by the meals the bottom steak
pasta vegetarian
and we can see store one store two and
store three store one is blue
and then we have orange for store two and
yellow for store three
on our left we see the number sold showing
the most
being pasta in store one so we
we can check another type of.. what if we went to..
line chart and lines only
it I don't think this works for
the purposes were looking for so we are 
going to stay with the column and
we've selected our chart type let's look at
the data
range the data range is B4 to
E7 which is our group we have
the series in columns the first role was
labeled
and the first column is labeled so we're
happy with the data range
let's look at the data series now in our
data series
we've got data range range for name
categories in our data series we've got
store one
store two and store three so in
store one we've got our Y values are C5
to C7 which is basically this column
underneath store one when I look at
store to this changes to D5
to D7 and the range for the name
is D4 when I change to store three
this changes to E4 and the
data range is showing this information
under column E
the categories is B5 to B7
this doesn't change when we change our
data series because we always want it to
be the steak pasta vegetarian
now if we go back to the data range
change this to series in rows then we
come to the
data series now we see the steak pasta and 
vegetarian here
and the data values now are going across
instead of down
pretty simple to understand once you
see it with all with data
for the chart elements just given it
title we're going to say... restaurant
chart
subtitle it's just the a little line right below
so you could have more than one line there
the X axis is already pretty much defined
and the Y axes
were going to call this number sold
and the legend you can put it at the
left right top to bottom we're gonna
leave it on the right
we can display grid lines we're just going
to leave the Y
and gonna say finish so
here it is with the stores at the bottom
and the steak pasta
vegetarian in the legend our number sold
kinda shows the the numbers here we showed
how to change the
legend and the colors all in the
previous video so we're not gonna go
over that again
but I will copy this
cut I'm using control X now I'm going to sheet 2
control... I'm just going to pasted it
with the
shortcut menu now that it's here I've
got the green
and I want to stretch this out just to
make it fill the page
better so there's my first restaurant chart
for our next chart we wanna select the
meals again now I'm holding down
control and I'm highlighting
our store 1, 2, and 3 under the income
now when I hit chart it creates a new chart
I'm just gonna jump right to finish here
and we can see that the dollar signs
showed up for how much money came in
for each meal by restaurant
so when showing in this example is that
the data doesn't have to be right
next to each other you can highlight
some
and hold down Control and
headlights more data and create another
chart
all all all
