Change format of Trellis Grid?

[Glenn_Renwick]

Is it possible to change the format of a trellis grid from dotted grey lines? I would like to remove the grid.

[#2]

Any luck ?

I am also looking to get rid of dotted line along with change in font size of Dimension used. Any help?

[ThornOfCrowns]

I can't see any way to do that via the Properties of the chart.

[#4]

Is there any other way fo doing it like macros.

[c_gilbert]

You can change the font size of the Dimension label, by going into Chart Properties > Axes > Dimension Axis section > Font

I don't think you can change the grey dotted line which divides the trellis charts - the other other option I can think of is to cover them up with borderless text boxes.

[#6]

Covering with borderless text boxes will result in static formatting if going forward data in dimensiion increases it will break up e.g country dimension I may have 5 countries only but going forward it may increase and so as grey line will appear.

I am looking to create a graph similar to attached (Required) one. I am using Combo chart ( Trellies) to achieve it. Able to get everything (Achievedsofar.png) accept formatting of dimension values and removal of grey dotte line