从数据库里用Hive导出了30000+行的数据,每天31或32个点,要画每天的折线图。
其实用R也可以实现,只不过数据在Excel里,干脆就写了一段VBA。
Sub PicOutput()
Dim i As Long
Dim dayCount As Integer
Dim pointid As String
Dim iCount(32) As Long
On Error GoTo ExitThis
i = 2
dayCount = 0
pointid = Sheets(1).Cells(i, 1).Value
iCount(dayCount) = i
dayCount = dayCount + 1
For i = 3 To 32923
If i < 32923 And Sheets(1).Cells(i, 1).Value Like pointid Then
iCount(dayCount) = i
dayCount = dayCount + 1
Else '画图
Dim myChart As Chart
Set myChart = ActiveSheet.Shapes.AddChart.Chart
With myChart
.ChartType = xlLine
.HasTitle = True
.ChartTitle.Caption = pointid
.SetSourceData Source:=Wo