Tag Archives: Charts

Plotting Mandelbrot

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

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

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 …

… 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

Secondary axes in Excel 2007

Sometimes rarely used features in an application are so prominently placed that we become blind to them, and can’t find them when we need them. This happened to me recently with the procedure for assigning an Excel chart series to … Continue reading

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

Drawing in Excel – 1

This is a the first of a series of posts describing how to produce scale drawings in Excel, based on a list of coordinates. This post will cover the use of XY graphs, or scatter charts as Microsoft likes to … Continue reading

Posted in Charts, Drawing, Excel | Tagged , , , | 5 Comments