How to Change Chart Style in Excel (with Easy Steps)

Charts are essential tools to visualize data in Excel. When you start work with an extensive dataset, you will need to visualize your data to present the dataset smartly. In this article, I am going to describe how to Change Chart Style in Excel. At last, By following these steps, you will be able to present your data more attractively.


Download Practice Workbook

Please download the workbook to practice yourself


4 Quick Steps to Change a Chart Style in Excel

Let’s consider a dataset of Yearly Sales of ABC Traders. Here, this dataset consists of 2 columns. Moreover, the dataset is ranging from B4 to C10. Then you can see, that the two columns of the dataset B & C indicate Year and Sales respectively. Hence, with this dataset, I am going to show how to Change Chart Style in Excel with the necessary steps and illustrations.

Dataset to change chart style in excel


Step 1: Insert a Bar Chart from Chart Option

  • First, Select the Insert tab in your Toolbar.
  • Then Select the Bar Chart option. You will find a dropdown menu there.
  • After that, Select the first option of the 2D Column section.

Insert a chart to change chart style in excel

  • Hence you will get the chart just like the one shown below.

Insert a chart to change chart style in excel


Step 2: Insert Axis Title and Data Labels in the Chart

  • Select the Chart first.
  • Then, Go to the top of the right side and Select the Icon indicated in the next picture.

edit a chart to change chart style in excel

  • After that, Select the Axis Title & Data Label check boxes.
  • As a result, you will find the chart just like the one mentioned below.

edit a chart to change chart style in excel


Step 3: Edit Chart Title & Axis Title

  • First, Double Click on the Chart title. Then Edit the title to Sales vs Year.
  • Hence Double Click to the X & Y axis title. Change the titles to Year and Sales respectively.

edit to change chart style in excel


Step 4: Apply Chart Design Tab to Change Chart Style

  • First, Select the Chart first.
  • After that Go to the Chart Design Tab.
  • However, Select the Quick Styles option. Hence, you will find some themes in the chart. Select one of them.

how to change chart style in excel

  • As a result, you will find the same option by selecting the Icon shown in the next picture.
  • Hence, Select the Styles option.

how to change chart style in excel

  • At last, Select the Color option to Select a Color Palette for the columns.

how to change chart style in excel


Apply Different Chart Styles in Excel

In this part of this article, I will show different Chart Styles to make a quick edit. However, this will help you to Change Chart Style in Excel smartly. This is a handy way. Here, from this portion of this article, you will get an extended knowledge of how to Change Chart Style in Excel.

Style 1: Apply Gridlines Only

In this style, the chart has only horizontal gridlines.

how to change chart style in excel

Style 2: Show Datalabels Vertically

The chart shows vertical data labels in this stylehow to change chart style in excel

Style 3: Use Shaded Columns

The columns of this chart are shaded with colors.

how to change chart style in excel

Style 4: Apply Thick Columns with Shadows

In this style, the columns of the chart become thick with a shadow.

how to change chart style in excel

Style 5: Apply Bars with Shaded Grey Background

The background of the chart becomes shaded with grey color in this style.

how to change chart style in excel

Step 6: Use Light Color in Columns

Columns are in light blue color in this style of chart.

how to change chart style in excel

Style 7: Use Light Gridlines

The horizontal gridlines are in light colors in this style.

how to change chart style in excel

Style 8: Apply Rectangular Gridlines with Shades

In this style of chart, vertical and horizontal gridlines are added.

how to change chart style in excel

Style 9: Select Black Background

The chart has a black background in this style.

how to change chart style in excel

Style 10: Apply Shaded Columns

The columns become shaded in color near the x-axis in this style of chart.

Style 11: Apply Columns with No Fill

Columns do not have any fill in this style of chart.

Style 12: Apply More Horizontal Gridlines

Horizontal gridlines are added just like style 1 but more in numbers.

Style 13: Select No Fill Columns with Black Background

In this style, the chart columns have a black background as well as no fill in them.

Style 14: Apply Shaded Columns with Blue Backgrounds

Here, the chart has a blue background as well as shaded columns.

Style 15: Apply Increased Width Columns

In this style of chart, the column widths are increased to make the graph smarter.

Style 16: Apply Glowing Effects to the Columns

In this style of chart, columns are in glowing effects.


Things to Remember

  • In this article, only the column charts are taken as an example. But, you need to follow the same procedures mentioned in the first part of this article to Change Chart Style in Excel for other charts like Scattered Char, Pie Chart, etc.

Conclusion

I hope these steps will help you to know how to Change Chart Style in Excel. As a result, I think you will find interest in this method. First read the article carefully. Then practice it on your PC. After that, if you have any kind of queries, feel free to ask me in the comment section.

Souptik Roy

Souptik Roy

Hello there. This is Souptik Roy. I graduated from Naval Architecture & Marine Engineering department. I am trying to explore the world of Microsoft Excel and want to increase my analytical power apart from my Engineering degree, as I have a curious mind. this is why I am trying to learn Excel Operations and write articles to help others.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo