Recent Comments
Tag Archives: Chart
Plotting Charts With Gaps …
“How do you get VB6 to initialize doubles with +infinity, -infinity and NaN”… and various sorts of Not a Number. Back in 2012 (When is an xy chart not an xy chart) I concluded that it was not possible to … Continue reading
Posted in Arrays, Charts, Charts, Excel, UDFs, VBA
Tagged Chart, NaN, plot blank, XY chart with gaps
5 Comments
Displaying trend line equations on line charts
This post is prompted by a recent comment at Using LINEST for non-linear curve fitting which found that the trend line formula displayed on a chart was totally different from that found using the Linest function. The problem was caused by using a … Continue reading
Posted in Charts, Charts, Excel, Maths
Tagged Chart, Excel, Show trend line equation, Trend line
Leave a comment
Charting a Mathematical Function with Defined Names
This post is a compilation of information from Stephen Bullen, Jan Karel Pieterse, and George Lungu. To quote JKP “When doing mathematics, wouldn’t it be nice if we could type an equation into a cell in Excel and immediately see … Continue reading
Posted in Arrays, Charts, Excel, Maths
Tagged Chart, defined names, Excel, Lissajous Figures, plot function
7 Comments
Automating chart scale limits
Edit 22 Mar 2014: Also see https://newtonexcelbach.wordpress.com/2012/11/25/automating-chart-scale-limits-update/ for improved version with download link, and example of plotting a chart from a formula entered as text. One of the more annoying things about Excel charts is that if you want to … Continue reading
