How to Change the Chart Style to Style 8 (2 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

Microsoft Excel is a great tool to create charts as it offers many predefined layouts and styles. We can even create our own customized style. In this article, we are going to learn how we can change chart style and set it to Style 8 which is one of the sixteen predefined styles that Excel provides. So let’s get started.


Change the Chart Style to Style 8: 2 Easy Methods

In this section, we will demonstrate 2 effective methods to change chart style to Style 8 in Excel with appropriate illustrations. But before that, first, let’s take an example where we have a data set. (see the figure below)

Based on this data, we have created a chart.

As we can see, this chart is in the default style, Style 1. On the other hand, there is a total of 16 predefined styles in Excel (Style 1, Style 2, and so on). and sometimes, we may need to change the style of the chart to suit our needs and preferences. For example, maybe we want to change the style of the chart to style 8. Here I have listed 2 methods to change chart style to Style 8.


1. Use of Chart Design Tab to Change Chart Style

In the first method, we will use the Chart Design Tab to change the chart style. To do that, follow the steps below.

Steps:

  • First, click on any part of the chart. As soon as you click on the chart, you should see a new tab has appeared on the ribbon.

Use of Chart Desing Tab to Change Chart Style

  • Now, click on the Chart Design You should see many options like the figure below.

Use of Chart Desing Tab to Change Chart Style

  • Then, click on the arrow sign (â–¾) marked by the red rectangle box in the figure above. You should see all the predefined chart styles appearing.

Use of Chart Desing Tab to Change Chart Style

  • Here, we can see that the current style is Style 1.
  • Subsequently, if we select style 8, we will get the result shown below.

Use of Chart Desing Tab to Change Chart Style

  • Hence, our desired Style 8 chart will be like this.


2. Changing Chart Style with Chart Styles Tool

There is another alternative way which is quicker than using the Chart Design tab. Here we will use one of the tools that are adjacent to charts. To do that, follow the steps below.

Steps:

  • First, click on the chart. You will see a toolbox containing 3 tools just on the right side of the chart.

Utilize Chart Styles Tool to Change Chart Style

  • The 3 tools that we can see are Chart Elements, Chart Styles, and Chart Filters respectively from top to bottom. They are very handy tools to customize the chart.
  • Then, we will click on the Chart Styles option.

Utilize Chart Styles Tool to Change Chart Style

  • Consequently, you will see many style options similar to what we have seen in method 1. As we want to select Style 8, scroll down below.

  • As we hover the mouse cursor around styles, we will see a preview of the style on our chart. Now, select the Style 8.

Utilize Chart Styles Tool to Change Chart Style

  • As a result, you get your chart in Style 8

Utilize Chart Styles Tool to Change Chart Style


Things to Remember

  • We can change the layout as well by using the 1st method.
  • We also have the option to change the color of the style.

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Conclusion

That is the end of this article. Hopefully, you have a fair idea of how we can change the chart style to style 8. If you find this article helpful, please share this with your friends. Moreover, do let us know if you have any further queries.


Related Articles


<< Go Back to Chart Style in Excel | Excel Charts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Aniruddah Alam
Aniruddah Alam

Md. Aniruddah Alam, a graduate of Bangladesh University of Engineering & Technology, Dhaka, holds a BSc.Engg in Naval Architecture & Marine Engineering. Joining Softeko in August 2022 as an Excel and VBA content developer, he has authored 90+ articles, covering fundamental to advanced Excel topics. He actively develops VBA codes for Excel automation and offers solutions in the Exceldemy Forum. Beyond work, he finds leisure in reading books, and taking relaxing walks, showcasing well-rounded blend of professional and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo