There are many different ways you could visualize this data for your boss.

Some people might create a new line in their spread sheet and

sum up the grand total revenue for the retailer work.

Let's do that together, I'm gonna scroll down below and do a Grand total.

And then, here in cell B75, I'm going to enter equals,

take the revenue for the third location, and

add in the revenue for the second location.

And then, finally the revenue for the first location.

So we see here that total revenue in January was $7,005.

Let's carry this out through December.

What I'm gonna do is I'm gonna go up one row, I'm gonna hit Control,

go over to December here, and add a 1.

Then, I'm going to hit Control and go back, Control Copy.

And then, using the keyboard shortcut, holding down Control + Shift, and

then I'm gonna press the right arrow.

I've selected all those cells I wanna copy this formula to.

I wanna press Command + V, and there we we go.

So we wanna graph this, so I'm gonna again select all these cells and

using the keyboard shortcut Alt + N.

And let's do 2-D column chart, And there we are.

So this is indeed a chart showing total sales.

Now, I wanna make sure that it's crystal clear to our boss that the x

axis labels are the months.

So instead of having numbers, I'm gonna go ahead and get those labels in there.

And find our chart again, here we are.

So that's one way to do it, this could be a line

chart, Or it could be an area chart.

I think it'd actually be more useful if we showed a stack area

chart that includes the total sales for each location.

So let's go ahead and do that now.

What I'm gonna do is I'm gonna make a new sheet.

I'm gonna call this Location 1, Location 2, and Location 3.

>> Then I wanna go back over here To our locationInfo Sheet and

make references to this spreadsheet,

And finally Location 3 is right there.

And then I'm going to copy these formulas and carry them all the way out.

So, Okay,

and all those hashes right there are actually numbers.

It's just they're too big to display in the cells.

So what we need to do is we need to, I'm going to select all these columns.

And I'm gonna double click up top to the right to open them up.

And let me get rid of these decimal places.

Now I'm going to create a stacked area chart.

Alt+N and again and here's the stacked area chart.

And you can see that you're answering the question about total sales for

the retail network because the stack total shows you what those numbers are.

But you're communicating some more information by showing the breakout of

the contributions from each different location.

Some of you might be wondering, well why not break it down even further?

Why not show each individual item that we sold?

Well, check out the next video.