How do I add a color scheme to an Excel chart?

In Excel, click Page Layout, click the Colors button, and then pick the color scheme you want or create your own theme colors….Change the color of a chart

  1. Click the chart you want to change.
  2. In the upper right corner, next to the chart, click Chart Styles .
  3. Click Color and pick the color scheme you want.

How do I create a chart template in Excel?

To apply a template to an existing chart, right click the chart and choose Change Chart type. In the window that opens, select the Templates folder. Then choose a template and click OK. The template will then be applied to the chart.

How do I change the series color in an Excel chart?

To change the color of a data series:

  1. Select the data series you wish to edit.
  2. Click the Format button on the Chart toolbar (or double-click the data series).
  3. Use the Format Data Series dialog box to pick a new color.
  4. Click the OK button to accept the Data Series color changes.

How do I import a template into Excel?

Select an item in the System panel and choose Home > Excel > Excel > Import from Excel.

  1. Select the type of data to import from the Import Type drop-down list.
  2. Choose an import mapping template. You can: Choose a previously defined template from the drop-down list.

How do I access chart templates in Excel?

To apply the Chart Template to a new chart:

  1. Click a Chart button on the Insert tab of the ribbon to open the Insert Chart window.
  2. Click the Templates tab on the left sidebar.
  3. You will see a gallery of your Chart Templates.
  4. Press OK.

How do you create a donut chart in Excel?

On the Insert tab, in the Charts group, click Other Charts. Under Doughnut, click Doughnut. Click the plot area of the doughnut chart. This displays the Chart Tools, adding the Design, Layout, and Format tabs.

How do I change the color of data in Excel?

In a chart, click to select the data series for which you want to change the colors. On the Format tab, in the Current Selection group, click Format Selection. tab, expand Fill, and then do one of the following: To vary the colors of data markers in a single-series chart, select the Vary colors by point check box.

How do I create a sunburst chart in Excel?

Create a sunburst chart

  1. Select your data.
  2. Click Insert > Insert Hierarchy Chart > Sunburst. You can also use the All Charts tab in Recommended Charts to create a sunburst chart, although the sunburst chart will only be recommended when empty (blank) cells exist within the hierarchal structure. (

Can Excel do pie charts?


  1. In your spreadsheet, select the data to use for your pie chart.
  2. Click Insert > Insert Pie or Doughnut Chart, and then pick the chart you want.
  3. Click the chart and then click the icons next to the chart to add finishing touches: