 So now I'm going to cover how you might want a better format graphs in Excel because the defaults are a bit They're a bit ugly So I've got some concentration and absorbance data here. It's effectively random numbers I'm going to insert a scatter graph and It's only ever going to be a scatter graph You don't want to be if it's data like this. You don't want to be connecting the dots You because we want to something to have a straight line and read and my rule of thumb would be you either connect the dots or You fit a straight line to it in this case. We want to fit a straight line to it to get a gradient and Let's put that on now just show it right click trend line So we want that server connected and how do we want to tidy this up? Well, there's a couple of things Wrong here that I think we need to get rid of immediately and one thing is this title Usually if you're doing first-year undergraduate chemistry or school level chemistry someone will tell you do my graph of and Then you'll type in whatever the x-axis and the y-axis are Um, I would recommend not doing that if you're going to write a report I would just delete that because we're going to use figure captions instead And one thing I think to get rid of because they're not always useful You can include them if you think they're useful. I usually get rid of the Lines in the background if they get a bit bit distracting Now you might also want to consider putting the equation of the line and the R squared on But again, we're going to stick that in the figure caption. We'll see this in a minute The one thing I would probably change first is These axes So what you can see here is that all those numbers are 1.0 0 0 9.0 0 for 0 0 a bit much, right? The reason that it looks like that is because Excel is taking the formatting From here and what I've done to here is this has got a number Style on it if you look at the top It's a number and there are certain numbers of decimal places One of the cheap and easy ways of doing that is just to keep knocking down the decimal places down to something reasonable And then what you get is Excel will update these axis titles to have that many significant figures Or decimal places, whichever Now that might be a problem because maybe you want all those when you copy this table into your report later So you don't want to get rid of them. So what we're going to do double-click on the axis And we're going to go into these axes options and the options that you fiddle around with are usually this little bar graph shape here Pick that and we're going to come down to number And what it has here is a number category and it lets you set the number of decimal places So maybe I just want one there you go one decimal place And that's overwritten what was in this column. I'm going to do the same for the bottom half Double I don't even need to double-click on this because this menu is still open Come down to the number section here decimal places one there you go, and that's now tallyed up Couple of things that's let's tally this up a little bit one. I've got the axis selected I want to go into the format tab shape outline and set it to black Same thing for here that so again optional, but the default is a kind of a gray color. Maybe you want to Make it stand out a little bit better when you are putting it into your report I'm going to highlight it and make sure the font size is reasonable. I'm going to boost it up to like 11 or 12 and Maybe that's a bit too dense. So if I highlight that Colour that axis come down to Is it under tick marks? I can never remember these major units there it is under the axis options I want to set the major units to be 0.2. So it's only going to put a unit on every 0.2 0.1 that tallys things up a little bit Right now I'm going to copy that right click go into a word document and paste it in Just control C control V One thing I haven't added here are axes because I'm feeling as I'll add that back in a second And you get this bounding box there, which is actually I think I think that takes you out of the document It makes it look like you pasted in a graph from Excel. It doesn't really integrate very well. So let's Let's go back to Excel and get rid of that. So the way to get rid of that is by selecting the whole graph Jump to the format tab and then the shape outline there no outline Now if we copy it Go back to our word There you go. Now it looks a little bit more integrated that looks like it belongs there. So if I do My insert my figure caption I can put all my a graph to show information There and there I would include things like what's this graph for? What's it doing? What are the outliers? Why are the outliers there? What are the what's the intercept and the gradient and what are the standard errors of those? I would put that information in the caption Yeah, may as well did yeah, let's go ahead and do that Delete that go back to Excel and we'll do it. I'm gonna Close that now highlighting this. I'm gonna put access titles on maybe I'll do Concentration or just conk slash molar doesn't really matter and then here absorb absorbance and Let's Let's get the data for this. So here. I'm gonna highlight my four squares typing the line st. No one wise Those are my why values no nexus that value comma True to set the intercept normally true to return the additional regression statistics close out bracket and control shift return So and then I will probably try Coral to return the correlation coefficient. I'll just stick those two in there So that's all my data now if I Copy that to put it back into word Yes, put something better than a graph to show shall we increase the size of this Celebration graph of five points from Concentration 0.1 to 1.0, and I will probably say look what was the gradient 0.81 plus minus No point a plus minus point one. Let's do that an intercept Learn to remember these numbers 0.07 plus minus 0.08 Not a very very accurate intercept. That is it. That's pretty much zero And maybe we could add units on that if we wanted So that would be a much better looking graph and more informative caption here as well So it may as well stick the correlation coefficient in there Not nine five Make sure that R squared is super scripted So we look at something like that. That's a little bit better probably a thesis style document if you Want to do it as a two-column layout you'd probably need to make sure that this font size is appropriate But that's the main thing to really consider so that hopefully gets you a slightly better looking Chart if you do it enough like this and you learn how to format Excel Probably everyone then immediately assumes that you are using professional software and not Excel for it Which is always a fun thing to do Hope that lets you produce a slightly better graph using this software and hope to see it more in your reports later