Default chart settings

[Sol Apache]

I have created default colour settings for a chart in a template and from
this created what I would like to be the default chart. It has a legend, a
particular size, font and font size (no auto-resize), and no border, data
labels or coloured plot area.

However, when I use this to make the default chart, Excel puts a border
around the selected chart, and whenever I create a new chart based on the
default, it too has a border.

The new chart also has its own size.

Is there any way I can set the default to be borderless and be of a certain
size (ie non-Microsoft preset size).

Thanks

 

[Jim Gordon MVP]

Hi Sol,

I think you would need a macro to resize a chart to a specific size.
Excel has some built-in rules about making charts a certain size.

Same thing with the border. A Macro that fixes these things is not
terribly complicated. I used the macro recorder to remove the border
and this is what I got:

Sub Macro1()
With Selection.Border
.Color = RGB(0, 0, 0)
.LineStyle = 0
.Transparency = 0
End With
Selection.Interior.ColorIndex = xlAutomatic
Sheets("Sheet1").DrawingObjects("Chart 2").RoundedCorners = False
Sheets("Sheet1").DrawingObjects("Chart 2").Shadow = False
End Sub

-Jim