Recent Comments
dougaj4 on Beam geometric non-linear… Bob Jordan on Beam geometric non-linear… David Lim on Frame Analysis Resources dougaj4 on About Newton Excel Bach Jeremy on About Newton Excel Bach dougaj4 on Plotting Charts With Gaps… Jon Peltier on When is an XY chart not an XY… Lori on Plotting Charts With Gaps… dougaj4 on When is an XY chart not an XY… dougaj4 on Plotting Charts With Gaps… Kari Mahaffy on Solving simultaneous equations Cameron Wallace on Plotting Charts With Gaps… Bill Harvey on When is an XY chart not an XY… Bill Harvey on Plotting Charts With Gaps… Plotting Charts With… on When is an XY chart not an XY…
Category Archives: Charts
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
Using Matplotlib from Excel with xlwings – update
In February 2016 I posted a spreadsheet with examples of linking to the Python Matplotlib library with xlwings. Since then updates to xlwings required some changes to the python code, specifically plot.show has been replaced with pictures.add. The spreadsheet has … Continue reading
Posted in Charts, Charts, Excel, Link to Python, Newton, NumPy and SciPy, VBA
Tagged Excel, MatPlotlib, Python, update, VBA, xlMatPlot, xlwings, xlwScipy
Leave a comment
More on trend line equations on line charts
In the previous post we saw that if a trend line equation is added to a line chart it will return the wrong coefficients if the x values are not a continuous sequence of integers, starting at 1 (click on … Continue reading
Posted in Charts, Excel, Maths, Newton
Tagged chart trend line, Charts, Excel, line chart, XY chart
1 Comment
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
A mystery curve links to Jupyter
Reviewing some of my less visited links recently, I was intrigued by a post at The Math Less Travelled: The previous post at the site provides more details of the source of the curve, and some links to an interactive … Continue reading
Posted in Charts, Charts, Excel, Maths, Newton
Tagged curve generator, Excel, Jupyter, Maths, parametric curve, Python, Scatter chart
2 Comments
Managing Data Using Excel …
… is a new book by Mark Gardener, published by Pelagic Publishing.* It is subtitled “Organising, summarising and visualising scientific data”. The publishers say of the book: Microsoft Excel is a powerful tool that can transform the way you use … Continue reading
Posted in Charts, Excel, Newton
Tagged Charts, pivot tables, Scientific data analysis
Leave a comment
Pi day of the Century
In North America, where today is 3-14-15, it is Pi day, and since there are not 31 days in April, the rest of us have to go along with that as well. Not only is it Pi day, it’s the … Continue reading
