### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Beam actions and deflections by Macaulay's Method
- Cubic Splines
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using Goal Seek on Multiple Cells
- Deflections and Moments in Rectangular Plates
- Latex Maths Text in Excel

### Recent Comments

Latex Maths Text in… on Pint, MPmath and implied units… dougaj4 on The VBA Decimal data type Ludek on The VBA Decimal data type dougaj4 on The VBA Decimal data type Ludek on The VBA Decimal data type dougaj4 on About Newton Excel Bach Reinaldo Chohfi Jr. on About Newton Excel Bach Solving cubic equati… on Solving Quadratic, Cubic, Quar… David N on A Match Function Bug … dougaj4 on A Match Function Bug … SectionProperties up… on SectionProperties update updat… David N on A Match Function Bug … dougaj4 on Fitting 3D circles to scattere… Aaron on Fitting 3D circles to scattere… dougaj4 on 3D plots with the latest …

# Tag Archives: Charts

## XY Chart problems – 2

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 Charts, Excel, UDFs, VBA, XY chart, XY chart displays as line, XY chart with gaps
Leave a comment

## 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 Charts, Excel, Mandelbrot Set, VBA
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 chart trend line, Charts, Excel, line chart, XY chart
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

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