Style Chart Record For Free

Use the Chart Styles button to quickly change the color or style of the chart. Click the chart you want to change. In the upper-right corner, next to the chart, click Chart Styles. Click Color and pick the color scheme you want, or click Style and pick the option you want.

To format data labels, select your chart, and then in the Chart Design tab, click Add Chart Element > Data Labels > More Data Label Options. Click Label Options and under Label Contains, pick the options you want. To make data labels easier to read, you can move them inside the data points or even outside of the chart.

Select the inserted chart and then press Ctrl+1, a shortcut for formatting the chart. This will provide a sidebar next to the chart with different options to fill the bars will different colors, change the background texture, etc.

Click the chart that you want to format. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Design tab, in the Chart Styles group, click the chart style that you want to use.

Select a predefined chart style Click the chart that you want to format. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Design tab, in the Chart Styles group, click the chart style that you want to use. Tip: To see all predefined chart styles, click More .

Change the chart style Click the chart you want to change. In the upper right corner next to the chart, click Chart Styles . Click Style and pick the option you want.

Select the chart and go to the Chart Tools tabs (Design and Format) on the Excel ribbon. Right-click the chart element you would like to customize, and choose the corresponding item from the context menu. Use the chart customization buttons that appear in the top right corner of your Excel graph when you click on it.