vba Combined line and area chart in vba

[travellerva]

I use a vba macro to generate a chart that combines 2 lines with an area within the same axes. I use the area data series to emphasize that data rather than using other line characteristics such as bold, color or line width. The following vba commands are written after the data series and other parameters of the chart are generated:

ActiveChart.SeriesCollection(1).Smooth = True
        ActiveChart.SeriesCollection(2).Smooth = True
        ActiveChart.SeriesCollection(3).Select
        With Selection
            .Smooth = True
            .ChartType = xlArea
        End With

As can be seen, I want to have all 3 data series displayed with smoothed lines. However, although the 3rd line does show up as an area, there is no smoothing of the values. The other 2 lines are smoothed. I've tried reversing the ChartType and Smooth statements to no effect. Other than the lack of smoothing, all other displayed values and formats are correct.

Is it not possible to do what I want?

 

[Jon Peltier]

Area charts do not support smoothed line segments connecting the points.

I've been informally working on an algorithm to determine the coordinates of the smoothed curves, but it's rather a low priority for me, and I have to pay the bills .

 

[travellerva]

Thanks for replying. The good news is that I now at least know it is not a standard supported feature that I just can't figure out how to use.
To be honest, although it's annoying, I'll live with the deficiency and wouldn't push hard for the feature, so keep it on your back burner!