Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Automatic download of csv files
- Frame Analysis with Excel - 3, Continuous beam or frame
- Writing Arrays to the worksheet - VBA function
Recent Comments
Tag Archives: Dynamic functions
Dynamic charts
A frequently asked question is how to get Excel charts to automatically update when new data is added outside the original selected ranges. The most frequent recommendation (such as here) is to convert the data to a table, then insert … Continue reading
Posted in Charts, Charts, Concrete, Excel, UDFs
Tagged Dynamic charts, Dynamic functions, Engineer v Sheep, Excel, Plotting interaction diagrams, UDFs
Leave a comment