### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Fitting high order polynomials
- Cubic Splines
- The angle between two vectors, Python version
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Numerical integration with on-sheet calculations
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Taming Symbols in Excel

### Recent Comments

dougaj4 on Numerical Integration; Tanh-Si… Numerical integratio… on Numerical Integration; Tanh-Si… Numerical integratio… on Numerical Integration; Tanh-Si… Dave on Numerical Integration; Tanh-Si… dougaj4 on Numerical Integration; Tanh-Si… Dave on Numerical Integration; Tanh-Si… dougaj4 on Numerical Integration; Tanh-Si… Dave McCutchan on Numerical Integration; Tanh-Si… dougaj4 on Numerical Integration; Tanh-Si… Dave McCutchan on Numerical Integration; Tanh-Si… XY Chart problems… on Plotting Charts With Gaps… XY Chart problems… on When is an XY chart not an XY… XY Chart problems… on XY Chart problems –… dougaj4 on RC Design Functions 8_03 alan green on RC Design Functions 8_03

# Tag Archives: XY chart

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

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

## When is an XY chart not an XY chart …?

… and whan is a blank cell not a blank cell? To answer the first one, create a simple XY chart, with a single data range of 7 rows, with a blank row in the middle. This should display as two … Continue reading

## PView Function

As promised in the previous post, here are further details of the PView User Defined Function (UDF), included in the IP2 spreadsheet, which can be downloaded (including full open source code) from IP2.ZIP. The PView UDF works by multiplying the 3D … Continue reading

Posted in Arrays, Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, UDFs, VBA
Tagged Excel, perspective projection, PView, rotation matrix, UDF, VBA, XY chart
3 Comments

## Fitting high order polynomials

This post is a follow up to Using LINEST for non-linear curve fitting and the following comments from Scott Rogers and Lori Miller. Scott found that he was getting different results from Linest and the xy chart trend line for polynomials of … Continue reading