Category Archives: Charts

Arcs and arc-splines

Posted on August 17, 2018 by

I have added two user defined functions (UDFs) to the IP2 spreadsheet to generate coordinates for a single  arc, or a series of arcs connected (if necessary) by straight lines.  The new version may be downloaded from: IP2.zip As an example … Continue reading →

Posted in Animation, Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, UDFs, VBA | Tagged , , , , , , | 1 Comment

Plotting Charts With Gaps …

Posted on March 31, 2018 by

“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 , , , | 5 Comments

Using Matplotlib from Excel with xlwings – update

Posted on May 7, 2017 by

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

Displaying trend line equations on line charts

Posted on April 16, 2017 by

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

Editing Charts with the mouse

Posted on September 13, 2015 by

When editing chart ranges, to either change the limits of the range, or select a new column, I have been in the habit of either selecting a range and editing the text in the Formula Edit Bar, or right clicking, … Continue reading →

Posted in Charts, Excel | Tagged , , | 4 Comments

A mystery curve links to Jupyter

Posted on July 16, 2015 by

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

Baby Names and Pivot Tables

Posted on May 17, 2015 by

Baby Boom: An Excel Tutorial on Analyzing Large Data Sets is a comprehensive (and free) tutorial looking at analysing public databases of baby names, using Excel: There are professional data analysts out there who tackle “big data” with complex software, … Continue reading →

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