1、最终的效果大概是这样,颜色的范围自己定,可以用值,也可以用曲线,我这里是直接用了曲线的第1个值(因为我的范围是固定的),如果想根据范围的限定曲线来的话,可以根据每个X轴的索引来比较YValue的值,自己去循环一下就好了
2、两个函数第一个,传递需要变色的系列名称,还有范围系列的名称与颜色,看下面代码
Public Sub grSetTrendSeriesLimits(caption As String, LoLoCaption As String, LoLoCol As Long, LoCaption As String, LoCol As Long, HiCaption As String, HiCol As Long, HiHiCaption As String, HiHiCol As Long)
Dim LimitsCollection As New Collection
On Error Resume Next
LimitsCollection.Add LoLoCaption, "LoLoCaption"
LimitsCollection.Add LoLoCol, "LoLoCol"
LimitsCollection.Add LoCaption, "LoCaption"
LimitsCollection.Add LoCol, "LoCol"
LimitsCollection.Add HiCaption, "HiCaption"
LimitsCollection.Add HiCol, "HiCol"
LimitsCollection.A