Tag Archives: Charts

XY Chart problems – 2

Posted on 16/06/2020 by dougaj4

The previous chart post (XY Chart problems – 1) looked at problems plotting charts with very short data ranges.  An associated problem is plotting XY charts with data with gaps (see When is an XY chart not an XY chart …? and … Continue reading →

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

Plotting Mandelbrot

Posted on 15/09/2019 by dougaj4

There are many sites discussing the Mandelbrot Set, but not many examples using VBA to plot the set in Excel, so here is my effort: The spreadsheet (including open source VBA code) may be downloaded from: Mandelbrot chart.zip Note that … Continue reading →

Posted in Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, Newton, VBA | Tagged , , , | 3 Comments

More on trend line equations on line charts

Posted on 27/04/2017 by dougaj4

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

Editing Charts with the mouse

Posted on 13/09/2015 by dougaj4

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

Managing Data Using Excel …

Posted on 10/05/2015 by dougaj4

… 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