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
- Downloads
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Daily Download 4: Continuous Beam Analysis
- Deflections and Moments in Rectangular Plates
- Writing Arrays to the worksheet - VBA function
Recent Comments

Z on Downloads py_xlCBA – Sup… on py_xlCBA update 
dougaj4 on Downloads 
Z on Downloads py_xlCBA update | Ne… on Calling PyCBA from Excel 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
khoitsma on Continuous beam animations wit… 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
dougaj4 on Downloads 
dougaj4 on Installing Adobe Reader non-DC…
Tag Archives: XY chart with gaps
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 Charts With Gaps …
“How do you get VB6 to initialize doubles with +infinity, -infinity and NaN”… and various sorts of Not a Number. Back in 2012 (When is an xy chart not an xy chart) I concluded that it was not possible to … Continue reading
Posted in Arrays, Charts, Charts, Excel, UDFs, VBA
Tagged Chart, NaN, plot blank, XY chart with gaps
7 Comments