Dear forum,
I am making a lot of charts. I have used VBA to save most of the work, but the desired appearance is a blank white plot area, with no gridlines except for the X axis, no line separating the X-axis labels, and a vertical line separating series by X-axis categories. An example is:
To get the charts to look this way I am using gradient-fill gridlines (vertical and horizontal) to form (a) the x-axis, and (b) vertical line separating the categories. That is, by hand inserting three gradient stops (white – blue – white) for vertical, and three for horizontal. The verticals go at 48-50-52, the horizontals are more of a pain as the location of zero on the Y axis varies between charts.
When recording a macro, any change to the gridline format appears unhelpfully as “Selection.Format.Line.Visible = msoTrue”.
Any suggestions on where I might go from e.g. ActiveChart.Axes(xlCategory).MajorGridlines.Select to get the three gridlines applied to the verticals?
Many thanks!
Chris
I am making a lot of charts. I have used VBA to save most of the work, but the desired appearance is a blank white plot area, with no gridlines except for the X axis, no line separating the X-axis labels, and a vertical line separating series by X-axis categories. An example is:
To get the charts to look this way I am using gradient-fill gridlines (vertical and horizontal) to form (a) the x-axis, and (b) vertical line separating the categories. That is, by hand inserting three gradient stops (white – blue – white) for vertical, and three for horizontal. The verticals go at 48-50-52, the horizontals are more of a pain as the location of zero on the Y axis varies between charts.
When recording a macro, any change to the gridline format appears unhelpfully as “Selection.Format.Line.Visible = msoTrue”.
Any suggestions on where I might go from e.g. ActiveChart.Axes(xlCategory).MajorGridlines.Select to get the three gridlines applied to the verticals?
Many thanks!
Chris
