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前端其它相关文章!