Forum Discussion
How to access scatter plot data for smoothed lines?
Greetings. Excel must calculate the data it uses to plot a smoothed line in a scatter plot. How can I access this data?
2 Replies
Hi Sam,
For my knowledge if only you write some subroutine which repeats smoothing algorithm and calculate intermediate points yourself. See for example
Sergei, thanks for the comment. Yes, you are right. And I did find out that Microsoft uses a cubic spline algorithm, for which you can download a free software routine on the web. It worked out very well.
Tom
