If we think about the main programs that all of us have installed on our computer, there is no doubt that office suites are among them, and especially Microsoft’s, Office.
And is that yes Office is installed by default on most computers with Windows operating system, It is no less interesting to stop at some of its internal programs, as for example in the case of Excel.
Turns out that this time we wanted to talk about Excel for some very specific issues, which have to do with one of the tutorials that are usually asked about this application, about its trend lines.
What happens is that this platform for creating spreadsheets has a huge number of functions, and also allows us to develop varied graphics, although not everyone knows how to proceed.
Therefore, if what you are interested in is accessing a series of forecast results based on trends, you should know that in the next few lines You will find the information about it that will allow you to take advantage of this Excel feature.
What are Excel trend lines?
The first thing, in any case, will talk a bit more in depth about Excel trend lines, since we believe that many users do not know well what they are for, and what is the reason why they exist when developing graphics.
We must explain then that trend lines are nothing more than a series of graphing techniques, very common among specialists who have to predict trends in different areas.
They are mainly used in the stock market and stock market corizations., since thanks to this, investors or users can identify the progression of the value of these, knowing what decisions they must make in this regard.
If we get a little more technical we can say that you are Lines are drawn from the moles, which is how the significant maximums are known, or from the bottoms, which are the significant minimums, of each of the graphs.
Of course, for these graphs to be developed, we need more than two points to consider, since otherwise it is impossible to obtain a trend that is reflected through the Excel charts.
Also companies that want to think long and short term strategies can use this type of trend lines, since they can show ascending, descending trajectories, etc.
How to add a trend line in Excel?
However, we are sure that If you have come this far it is because you want to know the trick that will allow you to add a trend in Excel in a quick and easy way, so let’s go straight to the step by step about it.
Before that, however you have to bear in mind that not all Excel charts support trend lines. Some like pizza, radar, surface, and thread charts just won’t add them.
Yes now, to add a trend line in Excel follow these steps:
- Once you have the Excel file in question open and the graph ready, what you have to do to add the trend line is to click on the data series that will be part of the line
- You should consider that the trend line will start at the first data point that is part of the series
- At that moment, three buttons will be displayed next to the graph, and we are going to click on the first one, which has the + sign
- By clicking on this sign, a list of elements of the graph will appear, in which we can access, for example, the Trend Line, which we have to enable so that it appears once and for all
- At that time, by positioning the mouse on the right side of the box, you will make an arrow appear with several options, those of Linear, Linear forecast, Two-period moving average or More options
- You have to go to More options, where an even larger list will appear
- At that moment, you will be in a position to give the trend line a name, and advance with the forecast or go back, among other functions.
- When you have finished selecting your preferences, you accept, and the trend line will already be part of your graph
Have you been able to add your trend lines?