How To Change Chart Style In Excel. Select the chart first. Where is the chart styles button in Excel.
Click the Chart Styles More button. This displays the Chart Tools adding the Design Layout. Chart Style In Excel.
On the Design tab in the Chart Layouts group click Quick Layouts and then click the first chart layout Layout 1.
Once you find the style you like but you dont like the colour you can click on the option Change Colors here. Select Templates at the left then choose the template we just created titled Chart1. Click the chart that you want to format. Then click Kutools Charts Chart Tools Copy Format to Other Charts see screenshot.