Hello, Catherine here for a video on how to build a chart using Excel rather than a written procedure which can be difficult to understand when reading, well we offer you the video here. The steps I plan to cover with you here are roughly written on the screen to the right. That's several topics. So I'm going to get started right away. I'm continuing on the same subject as the previous capsules if you've already watched them there. So the sample lab report that's in your protocol book and all that. We have an example of a chemistry lab report. So here are the measurements and the results and I'm going to build a graph where we'll have noticed here the mass volume percentages as a function of density. So the mass volume percentages as a function of the density masses. So first of all to insert a graph, uh, a first method would be to insert it into the butter, finally insert a graph and then come and get an image of points like that. And there will be absolutely nothing in the graph because I didn't specify which point I want Excel to use. A second method would be to use the X and Y selection method with the control key held down. So for example, the X's that I want in my graph are the values that are here. Then I, as the Y values are not stuck to the right on these values, I press control. Right now I have my finger on control and I hold the key and then I select the other four. Then I let go of both. So I release the control button and the mouse and go back to insert. then graph in the scatter plot section and I choose the first one. And there, well it happens and I'm happy that it happens for the video. Sometimes Excel does what it wants. So basically, in a case where the points don't seem to correspond to the four coordinates I wanted to put in the graph, I'm going to show you how to figure it out. So uh you have a very handy feature. You often have two ways to get everything into Excel. By the way, you have a very useful function called the select data function. So I can go get it by right-clicking and clicking select data or I can come get it in the chart creation tab and come get select data here in this window. So maybe I can start by packing the graph here and then opening the window here. So, in that window, generally, there 's just one series there, and that's what interests us at the moment. Otherwise, there is a way to delete everything, then add one, and start again. But in series 1, so I'm going to modify it. I'm not going to name it, it's pointless. I just have one series, I don't need a label or a caption here. And I'm going to come and click on the arrow here to select the values in X which are the four which are here, then click again on the arrow. So there, it will record that my four X values go from 1.0045 to 1.0427 in boxes B12 to B15. I'm going to do the same thing for the four Y values. So I clicked on the arrow here. I'm going to select the four values in Y. I click on the arrow again and then click OK. And at that point, Excel has not yet fully refreshed for the chart. It's really the next time I hit OK that it should finish updating. And there we find ourselves in a context where we have four points. We are in the coordinate. Uh, we could wake up Excel a little bit here to find out how it came to decide to put points in the graph. There, we could make sure that they are commas. So, we could play with the display of the Xs to remind him that they are indeed numbers. We could also play with the display of the Ys to remember that they are indeed numbers. And we noticed that it adapts the significant figures accordingly. I will return to the subject of significant figures. Afterwards, you will see. I'm going to allow myself to compress the graph like this so that we can see here, uh, what it is. Uh, if you ever reversed the X and Y, you will simply use the same method. You will return to select data, modify. There, you will go and reselect the correct Xs, reselect the correct Ys, click OK, click OK a second time. And then it should go well. H and uh there you go. So, I'm going to continue on this topic. So I showed how to insert the chart, select the X and Y and select data or invert. There, often the title is already there. Okay, we agree that I mean the title text box is already there, but we'll add the others. So in the graph creation tab because we are still adding elements to the graph and not modifying them or making them pretty. So we're going to go to the chart creation tab , add an element to the chart. We can select the two axis titles like this. There, if you notice the ma at the bottom of the graph there, finally when I select uh main horizontal title , well it will be added like that. Another way to add a title and anything a little there on the graph, we come to click on the plus which is here and we come to the title section of the axes. We click on the little arrow here and we select the main vertical title like that. It will display the same way as if I had gone to look for it through the tab in graph creation. So there we have it, we added titles together. Then, as for the titles here, don't forget, we'll start by numbering the graph in the same way that we always number a figure or a table. So graph 1. And here, to go faster, I'm going to copy and paste the title that I had here simply. But we're going to make sure that we have a title of a nature, uh, like either context of the experience or usefulness of the experience. In chemistry, we don't want a graph title that tells us mass volume, percentage mass volume as a function of density, for example. So depending on where anything close to it should not end up in your titles. Uh, after that, well everything is a bit disproportionate there. Right now, I could always afford to grab the font just to go for a slightly larger graphic there. So. So, uh, that's it for that here for the axes, we're going to opt for words. So uh it could be more or less words. There, he's still pretty strong there. So, uh, and since it's in words and not in symbols, that means that it's still quite a lot to put in. Uh and so that's what makes that in Y, we're going to come and use something like a mass volume percentage of the NaCl solution with its unit and also the in parentheses. So here, I'm copying it instead of writing it from A to Z. Obviously, you'll write it from A to Z there when you're starting from scratch. So density of the NaCl standard solution in grams per ml. So if instead of copying and pasting you wanted to write something, well obviously you just highlight it, write something like that and then the title adapts accordingly. So that's it for that. Uh now that I've done my title, I can uh see it on zoom. Zoom, I could also talk about it later. There are two reasons, two places where I could have talked about it. What we want by Zoom is that we don't want the points to be in the middle of the graph because there is a lot of unused space at the top or bottom and or bottom and or left and or right. So, we're going to make sure that the points cover roughly 80% of our space. Obviously, in the top left, I'm still going to have this null space here. At the top right too, we have no choice, we have a space which is rectangular. We go from the first point to the last. I'll come back to the zoom later because you'll see that when we put the error bars and all that, it could play a role. OK? But and so at that point, I will show you how to change it if needed at that point. So. So I'm going to move on to the grid. So we want four quads, there are already two. There is already the main vertical framing and the main horizontal squaring. I can go through two ways to add the secondary. Again the most here, I come in grid then I come to select a minor. I admit that when I say main secondary, I should say major and minor. So we come to select for example the horizontal minor. I could immediately come and check the other one but I wanted to take the opportunity to remind you that the other way is in creating a graph add a grid graph element I come to look for the other minor one so which is the vertical one. So there, both will appear on the graph. The objective here is, and that's what I tried to write here. We want a visual that is millimetric. So what we mean by that is we want it to look like a little quad. So we're going to have the main good ones which are going to be a little darker gray, the secondary good ones which are going to be a little paler, they stand out. They look like they're almost like little squares. They're not dice, they're not squares that big, they're very small. So that's satisfactory. Generally, basic Excel functions like here, I mean their width, their color, it's okay. Otherwise, well we can play with it a little bit and I'll go and see with you in the zoom function a little bit later for the good ones, uh the good ones that we might want to modify. But first, I want to put the error bars because it can sometimes change the look of the graph. OK? So when we put error bars, so I'm going to type that again here. We will add standard error bars. OK? So as I wrote here. So we will come to the most for example. We will come to the error bar and we will come to choose standard error. There, you will notice that depending on whether I remove or replace my mouse, the zoom of the graph changes because the error bars occupy a space and then it shrinks if you want the points to be able to increase the area of the graph. But I'm going to select this anyway. And Excel gives us default values. OK? So for the error bars, the values that I want for the error bars are here, sorry. So a value that is fixed for the four values of Y and the four values that are here for the absolute inserts for the four values in X. So here are two ways to get there right away. First of all, to modify something on the graph, double- click on it. OK? So I'll also show you another way to do it a little bit later. I'll slip in here for the sake of demonstration. There we are in Y. Bre of error in Y. I told you it will be point03 everywhere. So one way to do it when it's the same value everywhere is to go to fixed value and go to 03 like that. I tab to move and then Excel saves. There, I just do a tab like that and there it gives me point 03. You see, you will notice that the error bar was for example big like that then it came to crash at point 03. We can hardly see it anymore. I'll come back to this subject later. And there, I'm going to click on the error bars in X because I need to go and modify the one in X to put the values that are here. These values, sorry for that, these values are a little different from one value to another, eh. So even at the level of the other numbers after 2 and 3, these are numbers that are different. So, we're going to select the values as if to tell Excel that it's not always the same fixed value. And so, to do that, we're going to go down a little bit lower. in the window that is here. Uh and we're going to come to personalize. You will notice that it is still the X error bars that are selected. So I know that's what I'm going to change. And there, despite clicking on customize, Excel still put something generic. It changed the look of the chart. It's okay, it's temporary. I'm going to come and click on specify a value. You see he put one there. Then there, that's why it gives more or less one. Uh, and we're going to change that right away. We click on the small arrow, we select the four values. Excel will take them in order because we already put the 4x in order earlier. So we don't have to worry about that if we select them in the same order. And we come to do the same thing for the second box. Basically what this means is that the bar on one side and the bar on the other will be the same length. So positive value, negative value. We do OK and we come back to something that looks a lot better. I would like to draw your attention to the fact that we can no longer see the Y error bars because they are behind the point and I am no longer able to select them because the point is too big. So when you are not able to select something and then open the pop-up window on the right to modify it, the simplest way is to go to formatting and select from the drop-down menu here what you are trying to modify. So there, I would be able to come back and select my error bars by clicking there like that. Now, if you notice, it's the error bar that's selected. Then it's confirmed here because it opened the error bar menu . Exactly, if I go and find the point to shrink it to allow me to see the error bar because we agree that the point does not give as much information as the intersection of the error bars. So I'm going to go and see as much as possible if I'm capable. Ronably, I'll go look at the error bars by shrinking the point. To change the size of the point, I'm going to go to series 1. In series 1, you see there, it selects the points. That just opened the window on the right for me, sorry for the fuzzy formatting of the data series. And there, we will go to the DIY tab. That's what I call it. OK? with the little jump of paint here and we will come in the background to take care of the mark because the point in Excel is a mark. So we're going to click on mark. We don't want a border at our mark for the filling, we'll go with what's automatic, that's not a problem. Except that the size of the point, we will instead leave it automatic or not put any, which could on the other hand be an option, but we like to see it a little anyway. We're going to come into predefined and we're going to shrink it. So here, I could try a 4, I could try a three, then there I could come and see next to it, can I guess my error bars by putting the 3. OK? If I want to dare to go to two, for example, so I go back here to the mark, mark option, I go down to I could and there we can't see the point much anymore. We don't think the graph could be bigger there either. So let's say I make it bigger, we can't really see the point anymore but we can at least distinguish the small error bars. So I'll leave it like that for now. It still allowed us to see the information we wanted to see here. So that's it for that. I can just slide it in like that. Excuse me for a second. That's how it is. And there, uh, I added the error bars. We saw for a fixed value, for a variable value and the size of the points. And here I will come back to the zoom, the good ones as needed also of the axes or the precision with the good significant figures. now that we're also going to have the good ones, the good ones, the good quads, the good axes and all that. So here's the thing, if I start by uh seeing the zoom, I might want to play with myself. I find that at the moment it is correct, but let's say that at the moment it was not in X, I would come and double- click on the values of the X axis and that would open the window here which is the axis limits, axis options and all that. OK? So I'm in the 4th little tab here, a tab that's more math than tinkering in the end. Then I would come and play with the value in the background as it is here. Excuse me just a second. The value which is here minimum or maximum. So right now it's going from 1 to 1.05. I could have I'll try something. OK. I tab. The graph goes from 0 to 2. So Excel decided to go with zero at that point. So from 0 to 2, it makes no sense. That's not what I wanted. So I'm going to go back to 1 on the left and then I'm going to go back to 1.05 as the maximum value to be able to find the interval that we had. It also allows us to have vouchers that are reasonable. If we ever wanted secondary X bonds that were smaller to get more squares, we could take 1 instead of taking 2. So at that point, that would give me smaller, uh, squares here there for example. OK? So that could be an option. However, uh, it's not necessarily the priority there in the sense that we'll also possibly move the graph into a separate tab and that will mean that it might not be there, it might not be there, it might not already be the priority to actually look at the millimeter side. And anyway, that's enough for now. So here is the zoom, it's correct. I showed you how to zoom in on X. You do the same thing on y if needed. The precision of the axes, that is linked to, sorry, linked to the x and y. So the values in y, we remember that it's this one, these are these. They had three decimal places. So the precision of the Y axis axes will also be 3 decimal places . But if you remember earlier when I came to play with the precision of my values, so here for example if I add a decimal on the graph, it added it too. So earlier, I had already solved my problem by making sure to display the correct decimals here. But otherwise, we'll do it another way. We're going to double-click on the axis here. We're going to close these options here in the number option, we're going to ask it how many decimal places we want. So in the math tab, here if you want, we close the first three sub-tabs, we open number and we come and put 3. And for x, we already have the right number too. We can come and play in it directly here as I told you, that should fix it. Otherwise, we select x and then notice, it says 4 and that's what we want. So, I'll leave it like that for now. And so I'm done with the precision of the axes. Next, I'm going to want to add a curve and its equation. So to add an element in the chart, I can come to chart creation add an element. This is one of two ways if you like. And the trend curve is often the linear one we want. In another case, follow your teacher's instructions at that time. Uh, and the curve is obviously added from the 1st to the 4th point because my data series is made up of the four points . And here, I could, I will make a small aesthetic parenthesis. There are some teachers who might prefer the curve to be a solid line rather than a dotted line. So quickly, we're going to double-click on the right or go and select it in formatting. Here we come to make sure that it is the trend curve. We come to the DIY tab here and there we come to very full and we come to look for a very full which at that moment would be composed of with a type of dash for example this one. OK? The type of dash would be this one and we could resize it there at the level of its width to 1 until it is as thin as possible, so that we can continue to see our points and our error bars. But that 's aesthetic and as I said, in some cases it could also have been the dotted line. If I double click on the right, the curve is actually there to use the general term, I can come here to the mathematical tab of the curve, I can come to the bottom completely select the last two boxes which allow me to display the equation of the graph and the r squared. OK? So it just created an equation box for me like this. Uh, I could also define the intercept in rare cases where it is necessary to force the curve to pass through a point X Y Z. This doesn't really happen in chemistry, but there you go, the option is there. Uh, after that, I'm going to close this and come back to it right away. After that, uh, we made these two points, we also made this point. Then we could play with the visual of the equation. So because it's not very clear when it's transparent like that. So we double-click on the trendline label. We come to DIY, we come to filling, we come to plain filling. And search me why it's this color by default. We come to choose white. And so there, at least, we have a label that's called a trendline label. So a box equation that is more readable. So that's it for that. It can also be framed. That's right, I was forgetting but still in the DIY tab, we might want a border. So just tick very full. We can also play with its color or thickness. But you know, we understand, I won't spend time on that. So that's settled too. As for the significants in the equation, you might be instructed to use those from gin to display your equation correctly. If that's what you were instructed to do, that means the equation of the curve will have to have no decimal places for the slope and no decimal places for the y-intercept. In my case, in my example in the video, if on the other hand you have instructions not to look for these uncertainties with me from your teacher, the instructions that you have there are in the chemistry notebook that you have where there is a table with the elements not to forget. OK? At the bottom of the second page of this table , the items not in a lab report, there are two paragraphs. So there is one of these two paragraphs which tells you that if you don't have to use I you go in terms of significant figure. So for example to know how to round an ordinate to the origin in this case we will use the precision of the ordinates. So here I'm missing a decimal because my ordinates have three decimal places. So I want my y-intercept to have a third decimal place. I'll have to get it generated by Excel. But I can't just write zero because it's easy. OK? So we're going to find out what this number is. Along with that, the slope is delta y over delta x. It's a division. Yes, there are subtractions in there, but let's say we keep that, let's simplify it to the fact that it's a division, we'll keep the significant digits of the x and y. So here, we should keep four or five. There, let me explain. Values in y have four significant digits. The values in x have 5. So at that point, we can always also validate with our teacher, here, I will keep uh I will keep four because half of my values have four and the other half have 5. So the least precise is 4. We are not also talking about keeping one or two there, so 4 seems reasonable but if necessary. We validate this kind of information. R squared always has 4 decimal places, it's in your guide, it's part of the convention. On the other hand, I told you there, I will go and find one more number to give them and whether you use I or not, sooner or later you will have to find more numbers for the slope or the ordinate. So, we're going to double- click on the equation. We're going to the future in the math tab here. And instead of using the number display which is called general, we will take the number display and we will ask it for four decimal places. Let me explain before I activate the 4. Look at the equation again. Excel has set R square to 2 by default. So if I want to go back and get my four for the R squared, I have to put four here. There will be too many for the slope and to give them, but I will erase them after. On the other hand, I wouldn't have added random numbers or added zeros by default. I went and got the correct numbers and will manually round after that as needed. So I can close that for now. I finished adjusting the significant figures automatically using Excel. From now on, I have to be sure of my move, but I will also explain to you how to get around the problem. From now on, you're going to want to uh play around in the curve equation. If you have n't finished setting up the graph or if you ever make a mistake, know that it is always possible to go back but by deleting the equation of the curve and having it regenerated by Excel. Because when you go to play with it manually, Excel will no longer recognize it . It will not be able to regenerate numbers for you. For him, it's made something unknown and it becomes something that you can just play with manually or as I said, erase it and start again. I'll come back to this later in the video. So, here you have your equation. I'm going to zoom in on it a little bit. We have different instructions, so respect the significant figures. So, we said earlier that our ordinates have three decimal places. So there, the 3, it is too much inside my uh of my of my my text box. So the 3 is too much. I'll come make sure to take it off. Sometimes Excel does that. Excel decides to move the cursor all the way down. So, if Excel ever gives you this problem, that is to say trying to delete the 3 and then it moves the cursor to the bottom, you can either try something else like moving the cursor, adding a letter anywhere, that will perhaps wake it up. Otherwise, you save your work, close Excel and reopen it. So sometimes that's the solution. Sometimes there is too much going on within Excel. So uh those are those are my two suggestions. So I'll start again. For the y-intercept, I want three decimal places. So I take away the 3. For the slope, we said four significant figures. So I take away the 8, the 8 and the 1. And I get 153.7. For the ordinal, excuse me, for the R square, everything is fine like that, I'm not touching it. Then for the symbols. So here, I will allow myself to come and look for the symbols here. So, we have the density of the solution that we can use as the X. So, I can control C, control V like that. I could take my little italic here and I could come to home to come to the police to put the SLN in index . So like this way for example, I could come and select the mass volume percentage of NaCl because that's my symbol. I just select the Y. I paste that here. Same as before, I select what I want to be the index. I come to my police. I just click on hint. I do OK. And I get in the background the equation which is here which, uh, what I was saying a little earlier, it corresponds, look carefully, it corresponds to if I use the significant figures, uh, which do not pass through. OK? So here I don't use gin. So I thought about significant figures and decimals. If, on the other hand, I was more in the example at the beginning than in the other video where I used Gin, it's 154 and 153. So, I rounded it like that. OK? So, we will respect this little detail which is not really a detail, but this difference between the two situations. And now, from now on, Excel no longer recognizes the equation. So in a little while, I'm going to explain to you how to get around this problem if necessary. And finally, often, you will be asked either if you have a report to print, or if you have a report to submit electronically, but often you will be asked to present the graph in large format, in landscape format, excuse me, in landscape format in a separate tab. So for that, well we're going to go to the chart creation tab and we're going to move the chart to a new sheet as a new tab. OK? Another way to do this is to right click and move the chart. Then same thing, we come to new sheet and we click OK. Excel generates chart 1 for us. For example, Excel generates, if you notice the grid earlier, I wanted to spend a lot of time on it. So he came up with the idea of enlarging the graphic but shrinking all the font, all the dots and all that, so it makes it a little bit more airy, a little bit more presentable too. There, that's where I could say well there, I'm going to come and play with my quads, my cadriots, my secondary grids to enlarge them like that for example or not to enlarge them but to put more, I meant to put more. I could come and look for this concern of making a grid, uh, also more square. So for example by making these settings there. OK? So that could also be what I just did. I could have also left the 1 at the beginning like that. Uh then in X on the other hand go for good Oops, I What did I do there? In X go for vouchers that would be in the background, I would like to have point05 like that. So that would also be correct. But as long as you have this concern of having the main and secondary grids which look like small squares and all that, well it will be correct like that. Here, I would also allow myself to increase the font size of the equation because, well, that's what interests us the most. We make sure that it is not on the points of the graph and so on. There, on the other hand, I'm going to do some Z controls to get back to my tab from earlier because I would like to get back to the everything list that I had to cover the last points that we had left. So I back away with control. Well, it doesn't want to go back anymore, eh, that's what happens sometimes. I'm going to move the graph back into uh example with graph like that. And so I'm back in the tab from earlier. So. And I set moved the graph. Then when you encounter problems, so for example, you are making your graph and then uh you have periods instead of commas in the axes. Excel wo n't move. The axes when you try to change them or the equations do n't work, here are some things to remember there. So first thing, did you use the comma instead of the period? And there, I speak as much in the tables as in the in the for example in the pages here on the right for the formatting of the graph and all that. OK? So we use the correct punctuation. Are you also good, do you have number or scientific functions for example and not text in the boxes that you selected to make the graphics? If you ever have a problem with the equation, you could erase it and start again. So right there, you click on it, you click delete. Then you double-click on the equation of the curve, you will display the equation and the R² coefficient and you will repeat what I did earlier. So with significant figures as needed, but at least there, Excel remembered that we wanted 4 decimal places. So there, we would have to remove the 3, remove the 8, the 8, the 1, change the x and the Y. OK ? So these would be possibilities for finding ourselves in the end with the right equation. So there I lost it. It doesn't matter. There, I'm going to continue the video anyway. If you have a window problem, for example, you can't see your points. You would like to see your points, but Excel is showing you the graph next to it. So, double click on the axes like I did before. Come change the minimum and maximum. So remember you have minimum and maximum and the good ones here are the primary and secondary units. So these are two different things. And when things go wrong, it's like when things go wrong with the computer and you want to throw it out the window, maybe that happens to you, well save your work, close Excel, maybe even the computer. OK? Restart. sometimes that's all it takes to give it that little boost it needs to work well. So that's it for that. And finally what I would have left to discuss with you would be three points here which are ultimately quite connected . So I'll do that right away if needed. You just don't listen to that part of the video. Okay, we understand each other. There, it ends here as far as the base of the graph is concerned. It was already a good 30 minutes. So I continue with uh in case you want to have want to remove a point. First of all, in chemistry, our minimum is four points. So here I am not in a situation where I could take away a point. But if for example, I invent a 4th, a 5th value for my graph. OK? Here, I could say, let's say I invent one and then I'm going to really modify everything there. What I'm doing there won't really make sense anymore. But for example 158. OK, so I write a bit of nonsense. There, I will come and select my data in Excel to add this point. OK, so now I would have a 5 point graph. We forget that he is a stranger at the start in my painting. It doesn't matter there. OK, so now I have a 5 point graph. So. Oh well, I'm going to change my X axis. I'm going to compress my X axis. Okay, same thing as before. I 'll make sure I have a good display like that. Same thing here. Is my display okay? I kind of woke up Excel doing that. I just click on my X axis. Then there, my limit goes from 1 to 1.05. I should put 1.08 maybe something like that. Yeah. 1.07. OK. so we can see the points like this. There, my error bar in the background, uh, I should also go and select it, just because I 'm here, I'm going to make it come and select a 5th error bar like that, we'll have something that holds up for the demonstration like that. So. OK? So example example, this is my five point graph. The curve has updated if you notice the equation. Since I hadn't changed the symbols, that was the advantage in the end . Uh uh the slope is no longer 153 and neither is the ordinate because I bought another point so it was simply recalculated. OK? So that's it for that. And where I wanted to go with that basically is that I now want to say to myself, well, if I look at my graph there, is there a point that is aberrant that I would like to remove? Yes, the last one, we'll say above all that I invented it. We'll remove the last one. And we're also going to do that , but what we're actually going to do is remove it from the equation that's already there, from the data series that's already there, but we're going to make sure that this point is still visible on the graph. So here's how we're going to do it. We will go to select data. We will modify the first series. We will remove the aberrant point from the first series. So I basically go back to the equation I had initially. I just do it like this. But I'm going to add a second series where my only x value is going to be the outlier. My only y value is going to be the other outlier. And I'm going to do OK. Small parenthesis, if ever the aberrant data is in the middle of another series, when you come to select your data, you will simply go over it. So for example, if the outlier was the third, I select the first two, hold down control, then select the other two. OK? Then, well, it's going to come and get me 12, 13, 15 and 16. That's not what I want here. OK? So I'm going to take all of that out and then I'm just going to take the first four for my series here. OK? So I click OK and Excel tells me OK, that's good, I have the first four points here which constitute the curve which, for example, would become valid thanks to the manipulation I just did, so what is the validity of a curve? Go read your guide to find out. This is where I couldn't get the graph to work, but that's not the point. OK? The point was really to show you how to do it. And now, before going any further, we're going to want the last point, the orange point, to be orange because it's a different series. We'll want it to have error bars too eventually. So these errors, then we will come to ensure in formatting for example that they are present and this is not the case. So if you notice series 2 doesn't have the error bars. So I'm going to click on the point, I'm going to go to graph creation, add the error bars of type error. There is nothing displayed there. I'll still go and see in the formatting if it went well. So, that added up. So, I come to X, I go to the math tab here. In X, well there, at the moment, we have fixed values because uh it's a single value, but I'm going to personalize it anyway to come and get the full value, you know, with all its precision too. Okay, so I'm just going to compress my graph to get there. So, I'm going back. Custom error bar. In x, I come to look for this error there. In positive and negative x, I come to look for this value there. Then, in y for the error bar, in y for series 2, the orange series, I come to find my fixed value which is worth 0.03, therefore 0.03. And so, I have my error bar here. I could also take this opportunity to narrow down my point. So here, I'm going faster than before because the goal, uh, it's not, uh, it's not to start again what I already did in the video, but well, it's to arrive at the result here. So now I have a point that has been removed from the curve equation that is there. It's orange instead of blue. It is presented in the same way as the others in the graph with its error bars visually it is the same and all that. We agree that sometimes it is in the middle of your other four points for example. OK? So it would n't change that it would be orange and that would be a series of data that would be different. Then, however, because we have a second series of data, what was not necessary earlier is to have a legend. So here, it will be relevant to add a legend. I'm going to press my face again. So add a caption. We can choose where we put it. Let's say I decide to put it at the bottom because it gives me a nice rectangle in the end . So I could have that here. Uh I could also come in uh select data to come name the series. So the first series could be the calibration curve there for example. So I'll do OK. And the second series, I could call it the outlier point. OK, so I'll go like this, we agree to be more poetic. So that's it for that. And there, oops. So. And so there, that covers the point that I wanted here which was that we only want a caption when it's relevant. Otherwise, it takes up space on the chart in the background that is not needed. Uh then from that, uh I might want to make sure in the end to have a point of intersection between two series. OK? useful for among other things a chemistry experiment where you have two sets of data there which look a bit like this there you want the two to intersect because they are respectively here and we want to extend them to see where the point of intersection of the two lines is. So I'm going to show you how to do it just with the blue line. I'm going to extend it to the right until it gets close to the orange dot and then you'll get the idea after that. OK? So it's actually called the forecast mode that you have in Excel. So, we double- click on the right that we want to extend. This doesn't mean that we add points to the four points that are there, but it does mean that we are going to extend in this case forward by a certain number of periods our axis of our bar, excuse me, in the direction of the X axis. OK? The periods work with the X axis. Here I notice again that Excel has taken X with points in the graph. So. So there, I brought back commas just so that it would harm me. In a few moments, I corrected the situation. It happens often. OK. You have to be flexible to ensure that you are able to turn things around. If I go forward 1, look how crazy it is there. So I find myself going really far. In fact the axis is not even it did not even go to 1. 1 means it really goes from 1 to 2. OK. So my graduations are too far, my graduations don't go from 1 to 2. So there, I'm going to try myself to extend by 0.2 for example or by 0.02 like that. Well, that's it. I wanted to find the value that would allow us to see it. So to go from 0 to 0.02, we end up with something that almost reaches the orange point. So I could put point 0 25 for example. There, I go past the orange dot. And there, it would depend on whether there is a straight line, a curve at the orange point. All you want is for her to cross paths. We don't need to continue there forever. So here we have with the details towards the front of a number of periods which attention is associated with your axis to the graduations of the axes. So here, by coming to look for 025 after the last point, well we arrived here. OK? And so there, it is enough for, as I said, to demonstrate what it is and how we go about finding a point of intersection between axes. So there you have it, I think that covers all the topics I wanted to cover. I hope if I ever forgot something, maybe look in the description in case someone decided to add some information for you. Thank you for your attention and I wish you a nice day.