Manipulating excel 2007 chart grid lines in VBA

Using Excel 2007, is it possible to change the transparency of chart grid lines using VBA or VB.NET? I have the following code, which throws an exception on the last line: Dim axis As Excel.Axis = chart.Axes(Excel.XlAxisType.xlCategory) axis.HasMajorGridlines = True axis.MajorGridlines.Border.Color = Color.Gray.ToArgb axis.MajorGridlines.Border.LineStyle = Excel.XlLineStyle.xlContinuous axis.MajorGridlines.Format.Fill.Transparency = 0.8 ( Of course, this code is in VB.NET ) Thanks!

以上就是Manipulating excel 2007 chart grid lines in VBA的详细内容,更多请关注web前端其它相关文章!

赞(0) 打赏
未经允许不得转载:web前端首页 » excel

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

前端开发相关广告投放 更专业 更精准