![]() So, don't expect a proper intersection with Y-axis.įor example, for a line chart, the vertical (Value) axis crosses the horizontal (Category) axis at a non-zero position - see the example above. Excel treats the Category axis values for all other chart types as the list to calculate the trend and its formula, where n is the number of text elements on the axis.Īttention! Excel takes the first value as x = 1, not x = 0 as usual. Excel generates a mathematically correct trend line using data values only for the XY scatter plot because the Y-axis and the X-axis are real numeric values for this type of chart.When creating a trend line, you should remember that Excel treats any data along the axes as numbers:.You cannot add a trendline for 3-D or stacked charts, pie, radar, and similar. In Excel, trendlines can be added for 2-dimensional charts only: a 2-D area, bar, line, column, stock, scatter, or bubble chart.Excel makes adding a trend line to a chart quite simple. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |