![]() An exponential trendline is a curved line therefore, you can’t use it if your dataset contains any negative or zero values. Right click the chart in your spreadsheet, and then choose Save as Template. The value of your investment will rise at a constantly increasing rate. Create a chart in Excel that you’d like to save as a template. For example, a graph showing the value of an investment with compounding interest can use an exponential trendline to illustrate the effect of the compounding interest on the investment over time. Use an exponential trendline whenever your dataset rises or falls at increasingly higher or lower rates. It’s important to choose the trendline that is the most meaningful for your data. The type of trendline needed will depend on your data. There are six types of trends or regression types. However, the following chart types don’t support trendlines: Changing a chart type to one that doesn’t support trendlines can remove the trendline.Ĭhart types that support trend lines include: Trendlines aren’t available for all chart types.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |