Excel 2007 Charting Wierdness

[hatman]

Has anyone noticed some wierd behavior for ChartType = xlXYScatterLinesNoMarkers? I have a small sample of data, like 100 columns by 5000 rows, with lots of blanks scattered throughout it. In 2003, it plots multiple curves per chart fine, with breaks in the curves right where they belong according to the blank cells. But the same charts in 2007 have entire curves missing from the charts. If you toggle through the series collections in the formula bar of the chart, the invisible curves are there (plus there is a corresponding entry in the legend), and the data gets highlighted when selected, but no line. Some charts had one or two curves missing, and others had all of them missing. We could not seem to repeat WHICH data sets were invisible and which not, on various builds of the charts (actually, a lot of the grunt work is via a macro, but even manual builds with different data sets behaved in a similar fashion).

So here we have curves that do not show up. Great. If we formatted the curve, and ticked on the Smoothed Line option, the curve would appear. Tick it back off, and it disappears.

So the fix in my code was:

                If Application.Version > 11 Then
                
                    CHRT.ChartType = xlXYScatterSmoothNoMarkers
                    
                Else
                
                    CHRT.ChartType = xlXYScatterLinesNoMarkers
                    
                End If

I really don;t understand why ther eis this discrepency between chart tyes in the 2 versions. Is this a feature or a bug? Has anyone else seen this?

Another aside: When you have an XY scatter with a secondary Y-Axis, and change the chart type to a different sub-group of XY, the secondary Y-Axis disappears, and all the data plotted against it reverts to the primary Y-Axis. I checked, and that behaviour exists in 2003 also.