Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Alternative iterative solvers
- Using LINEST for non-linear curve fitting
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Latex Maths Text in Excel
- Automating chart scale limits - update
- 3D Frames, axes and stiffness matrices
- Cubic Splines
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Taming Symbols in Excel
- Reinforced Concrete Section Analysis - with prestress
Recent Comments
Tag Archives: Dynamic charts
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