Logarithmic trend line : Useful when the rate of change in the data increases or decreases quickly and then levels out.ģ. Linear trend line : use it if data values are increasing or decreasing at a steady rate.Ģ. Slide share presentation3Rule of thumb : Use type of Trend line1. How to Create a Trendline? Have a look at my earlier post in LCDing Trend lines can be used to forecast future !ĢSix types of trend lines LinearLogarithmicPolynomialPowerExponentialMoving Average The magnitude of the slope of a trend line, or steepness, indicates the strength of the trend. Kindly exercise caution!in chartsA trend line is a straight line connecting multiple points on a chart.Ī trend is a movement in a particular direction Warning: This is for those who wish to explore trend lines in excel.For others, this presentation may be intimidating.

As a result, time formats that include a date only make sense when the cell contains both a date and a time.Computing trend line values using excel formulas and functionsTrendline values in excel charts Because these times don't contain a date component, Excel will display the first date in its date system. We can also use Format Cells to show a standard AM/PM time with and without seconds.įinally, we have the option to select a time format that includes a date. We can set time to display in military format-without the AM or PM-with and without seconds. To set the time format indicated in columns D through H, we need to use the Format Cells dialog. If you need to ensure that the display of time is always the same, it's better to use another format option. This means that this time format may look different on different computers, depending on regional settings. If we change the time format in Windows, in the Region and Language control panel, we'll see the change in Excel for cells that use this time format. The asterisk means that this time format is controlled by the regional settings on the computer. If we check this format in the Format Cells dialog, we see it listed first, with an asterisk. This is the format you get when you apply the Time format using the menu in the ribbon. Let's look first at the default time format in column C.

Let's start off by copying these times to all columns, then adjust formats to match those shown in the table header. Here we have a set of times in column B of our table. Like the Date format, the Time format includes a number of built-in options for displaying time. In this lesson we'll look at the Time format.

Using excel for timelines in genealogy