Chart Styles

Occasional Visitor

Hi so for my computer class I have to change my chart style to style 14 but I can't find the design tab on ribbon and am not able to change it please help

1 Reply


Click anywhere in the chart.

Press Alt+F11 to activate the Visual Basic Editor.

Press Ctrl+G to activate the Immediate window.

Type or copy/paste the following line:


ActiveChart.ChartStyle = 14


With the insertion point anywhere in that line, press Enter.

Press Alt+F4 to close the Visual Basic Editor.