1. Reduce the date values by deducting a suitable figure such as 1900 so the dates now only vary from -7 to 123. 2. Generally show more decimal places. 3. The surest way is to make use of the “LINEST” function in EXCEL. This function is generally described as returning the paramete...
Although there are a limited number of sparkline chart types, within each type you have a range of formatting options. In the line charts, you can draw the line only, you can add markers, and you can format positive and negative markers differently (there is apparently no distinction between...
Good enough! Incidentally, your dataset can be used to show that Excel must modify the Catmull-Rom spline algorithm to draw its smoothed lines, because Excel smoothed lines usually overlap that spline yet avoid the pathology that you found. As Answers.Microsoft notes, “An adjustment to the bas...
you can draw the line only, you can add markers, and you can format positive and negative markers differently (there is apparently no distinction between zero and positive markers). You can highlight the first and last points, and the ...