|
本帖最后由 黑山上的鹰 于 2015-3-30 09:21 编辑
图表求助.rar
(11.73 KB, 下载次数: 7)
,每月写分析需要手工制作10多个柱状图,费时费力,自己套用了一个宏,达不到要求,能否帮忙改一下,谢谢Sub ProductionCharts() Dim r As Integer
Dim rng As Range
Dim MyChart As ChartObject
On Error Resume Next
With Sheets("报表")
.ChartObjects("MyChart").Delete
r = .Cells(.Rows.Count, 1).End(xlUp).Row
Set rng = .Range(.Cells(3, 1), .Cells(r, 5))
Set MyChart = .ChartObjects.Add(120, 40, 400, 250)
MyChart.Name = "MyChart"
With MyChart.Chart
.ChartType = xl3DColumnClustered
.SetSourceData Source:=rng, PlotBy:=xlRows
.ApplyDataLabels ShowValue:=True
.HasTitle = True
.BackWall.Select
.ApplyLayout (5)
.Axes(xlCategory).Select
.Walls.Select
.Delete
With .ChartTitle
.Text = .Range("a1")
.Font.Name = "宋体"
.Font.Size = 14
End With
End With
End With
Set rng = Nothing
Set MyChart = Nothing
End Sub
|
|