Gridline weight

[Nick Turner]

Hi all

Is there any way to customise the weight of the gridlines in charts? I
know that there are the four standard weights using format gridlines, but I
was wanting a different weight that wasn't available through this way.

Is there a solution using VBA (or otherwise)?

Thanks in advance

Nick

 

[Andy Pope]

Hi,

The built in weights are the only ones available, even using VBA.

Jon Peltier has a page on make arbitary gridlines, although this is more
to do with spacing than line style.
http://peltiertech.com/Excel/Charts/ArbitraryGridlines.html

You don't say what style you where after but if it's heavy lines then
you can use the above technique and place 2 points very close together
to give the impression of thicker lines.

Another possiblity would be to use a custom marker. Create the required
line as an autoshape and then use CTRL+C to copy the shape and CTRL+V to
paste it as a marker on a xy scatter series. One major draw back of this
approach is the gridlines will then appear above other chart elements.

Cheers
Andy

 

[Nick Turner]

Thanks Andy

Thought that might be the case. I was wanting a very precise line thickness
so that when I export the chart to a graphics program and get it
professionally printed, I wouldn't have to change it manually.

Thanks for your advice, I will look into it.

Nick