Chart Styles

Copper Contributor

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

@brayduhn 

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.