 Do you need it to add other items within it? If I click on this, I just want to point out, if I click off of this table, we only, our tabs up top stop at, well, I have a quick book, you might not have this last tab over here, but you might stop and help, you might not have developer either. But the point is that if I click on this table, we get these two other tabs up top, the chart design and the formatting tab. So if I go into the chart design tab, you've got the add chart elements. So if I hit the dropdown, access, access title, chart title, data labels, we've got the quick layout information, you can change the color scheme fairly quickly up top. So this is the default blue, it's like the default color scheme. So anytime you want to look a little bit more unique, you might want to change it from the default. If you hit the dropdown here, you've got your other kind of custom designs within this area, so you can get the same basic chart. If you wanted to switch the row and columns easily, you can do that here. Here's the data set. So if I go into the data set, now you can see this is the word count and the information on the data set on the left. If I wanted to edit this, that shows us that this is the word count, the series and the series values being shown here. So if I wanted to change these, I could go into here and change where they're coming from, which we might do in future presentations. So I'm gonna close that, but we had it pull in by default correctly because we organized the columns properly with the words on the left and the numbers on the right so it can give us the word count on the X and the numbers on the Y as basically the default. Change chart type. So if we wanted to change the chart type, we don't have to delete it and do it again, which is what I normally do. You could just go here and change the chart type from here and move the chart. If we wanted to move the chart to a new sheet, notice I could say instead of putting it in the same sheet, maybe I want the chart in its own sheet and I can put it here and name the new sheet and then I'll make a new sheet down here so we can have it on its own if we so choose. And then if I go to the format tab, we've got some more the current section chart area. We've got the insert of the shapes, the shape styles, the shape fill on the colors and whatnot that we can put more information or more fancy stuff into the word styles and accessibility, arrange and the size. Now note you can go into a lot of those too by clicking on the elements in the chart. So if I click on the element, I could delete the title if I want or I can right click on the element and pull some options that way. If I wanted to do something with this sidebar, I can click on the sidebar and if I double click on it, it'll give me the information related to it on the right. If I wanted to do something with these bars, if I double click on it, it'll go to the format tab up top and I can change the color and whatnot. And I also have the information on the right which will open up here. If I wanted to do something to the format down below, I can double click on it here. So there's multiple ways to get into the same stuff. Also on the right hand side, if I hit the plus button, you've got some again, multiple ways to get into the same stuff a lot of the time. So we've got the axis, we've got the axis titles. So if I want to put a title, you can see on the axes, I can click on this and then I can click on say this title. And as I type in it, I can call this word count. Now it doesn't show up here, but I can see it up top. So it is doing it even though it's a little weird. I can say word count and then when I hit enter, it'll populate. And if I click down here and do the same thing, this is just gonna be the words and enter. So now we've got our names that we have in there. I can hit that if I say this is the chart title, the data labels, which are often useful to have. I can add the data labels if I want. So there's the data labels. I can double click on the data labels and get more information that we can, how we're gonna populate the labels on the right hand side if we so choose. And data table down below. We've got the error bars. So we could add a little bit more information on the error bars, the grid lines. You could turn them on and off. A legend. We don't need a legend because we only have one thing, but if we had multiple things on the bar and then a trend line, if we wanted to add the trend line. So there's just a basic overview of the standard kind of chart. So now that we've done this one time, let's do it a little bit more quickly with a similar thing for Harry Potter. So I'm gonna do this quickly on Harry Potter. I'm gonna go to the Harry Potter tab and we've got our data. So this is the most frequently used words in the series. So let's do this a little, I'm scrolling up, I'm holding down control, I'm scrolling up. I'm gonna pick my information. So I'm gonna pick this information. I like to make it into a table. So I'm gonna go into the home, to the insert and make it into a table. And then I like to format the data by highest to lowest. It's already formatted that way, but let's do it again. Hit the dropdown Z to A. And then if I wanna insert a table on this data, I can select the entire data set and it's as easy as going to insert and then charts. I could do the recommended ones and see some of these a little bit more unique or it's not a little bit different style of a table, but I'm gonna go to the make my own standard one like this way. So there's our table. And you might, let's do a sideways one. So here's the same kind of concept in the side format. So we just changed the axes. And then again, I can double click on the item up top and say this is Harry. I keep on saying Harry like Harry instead of the name Harry. I don't know if that's a Harry word count. And so there we have this one. And then we could make changes to some of these items if we want. If like this legend down here, if we wanted to change that, notice it's picking the minimum number and then the maximum. And it's going up by units of 1,000. So maybe we can change the look and feel of this a lot by saying, what if I wanted these units to not go up by 1,000, but 500 or something like that. Then it's gonna change, we could change the look of it. So let's put it back to 1,000 for now. We'll see that a little bit more when we get to the histogram or I can reset it to auto. Here's the auto set. It's at 10,000 and I put 500. So that changes a lot. But we'll talk more about that later. So this we'll just keep with this. So if I did the same thing down here, we have two frequencies. These are the most frequently used words in Harry Potter. And then they have, these are displayed frequency of nonstop words, meaning they're not like the and two, which are gonna be used more often. So these might be more relevant words in some cases because they've removed the most common words that might not be as much of interest. So let's do the same thing. I'll just insert a table and then okay, I'll sort it from Z to A and then we'll insert our table here, insert charts and I'll make another sideways bar chart to match the one above. And we'll say this is Harry word. Notice I'm looking up here because that's where it's typing word, frequency with this is for nonquote stop words. Quote and quote, nonstop word, there shouldn't be a quote here, nonstop words, okay. And this one, Harry word count, we'll just keep it with that. All right, you get the gist of it. You don't need to be all specific on it. And so we can kind of format these and that's the general idea. So now we'll move next time and see what if this was like numerical data over here or something, right? And then we might need to use a histogram which is similar to this and we can actually combine the data to still make use of bar charts. So we'll talk about that in future presentations.