Category Archives: Charts

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 , , , , , , , | 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 , , , , | 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 , , , | 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 , , , , , , | 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 , , | 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

Posted in Charts, Excel, Maths, Newton | Tagged , , , , , | 6 Comments

Charts and Charting

I don’t do a lot on Excel charts because there are already a number of excellent blogs and sites that specialise in that area; notably: Peltier Tech Blog but after compiling my “Downloads by Category” page I found that I … Continue reading

Posted in Charts, Excel, UDFs, VBA | Tagged , , , | Leave a comment