travellerva
New Member
- Joined
- Mar 31, 2012
- Messages
- 47
- Office Version
- 365
- Platform
- MacOS
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:
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?
VBA Code:
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?