WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Change Chart Style in Excel

Change Chart Style in Excel

By Jeevan A YJeevan A Y | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

How to Change Chart Style in Excel? (Step by Step)

Assume you have a data set like the below one.

You can download this Change Chart Style Excel Template here – Change Chart Style Excel Template

Chart Style in Excel Example 1

Step 1 – Select the data and insert the COLUMN chart in excel.

Chart Style in Excel Example 1-1

This is the default chart we get when we insert the column chart for the selected data range. Most of the people do not go beyond this step because they don’t care about the beauty of the chart.

Step 2 – Select the bars and press Ctrl + 1 to open the FORMAT DATA SERIES option.

Example 1-2

Step 3 – In the FORMAT DATA SERIES window, choose the FILL option, click on FILL and check the box “Vary color by point.”

Example 1-3

Steps to Apply Different Theme or Styles to The Chart

Now we need to apply some themes or different styles to the chart. For this, we need to follow below simple steps.

  • Step 1: Select the chart first.
  • Step 2: As soon as you select the chart, we can two extra tabs open up on the ribbon.

Example 1-4

We can see the main heading as “Chart Tools,” and under this, we have two tabs i.e., “Design” and “Format.”

Example 1-5

  • Step 3: Go to the DESIGN tab. Under this, we can see many design options. Go to the “Chart Style” section.

Example 1-6

  • Step 4: As we can see under chart style, we can see many designs. As per our current style of the chart, the first one will appear.

Example 1-7

In Excel 2013, we have a total of 16 chart styles. Click on the drop-down list of the chart style to see the list.

Example 1-8

There is no specific name to each chart style; rather, these styles are referred to as “Style 1”, “Style 2”, and “Style 3,” and so on.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

We will see each style of how they look when we apply them.

Style 1: Apply only Grid Lines.

If you choose the first style, it will display only GRIDLINES in excel to the chart. Below is the preview of the same.

Chart Style 1

Style 2: Show Data Labels in a Vertical way

Data Labels are nothing but the data or numbers of each column bar. If you select the Style 2 option, we will get below the chart style.

Chart Style 2

Style 3: To Apply Shaded Column Bars

This style will modify the style of the bars from plain to shades. Below is the preview of the same.

Chart Style 3

Note: Data Labels do not default in this style since we have selected Style 2 in the previous step; it has come automatically.

Style 4: To Apply Increased Width of Column Bars and Shadow of Column Bars.

This style will increase the width of the column bars and also gives the shadow of each column bar.

Chart Style 4

Style 5: To Apply Grey Background.

This style will apply a grey background to Style 4.

Chart Style 5

Style 6: To Apply Light Color to the Column Bars.

This style will apply light colors to the column bars.

Chart Style 6

Style 7: To Apply Light Gridlines.

This style will apply light grid lines to the chart.

Chart Style 7

Style 8: To Apply rectangular Gridlines.

This style will apply a rectangular box type of gridlines with shades.

Chart Style 8

Style 9: To Apply Black Background.

This style will apply a dark black colored background.

Chart Style 9

Style 10: To Apply Smoky Bottom to the Column Bars.

This style will apply the bottom of each column bar as smoky.

Chart Style 10

Style 11: Apply only borders to the Column Bars.

This style will apply only outside borders to the column bars.

Chart Style 11

Style 12: Similar to Style 1.

This style is similar to Style 1.

Chart Style 12

Style 13: To Apply Classy Style Type 1

This style will make the chart more beautiful, like below.

Chart Style 13

Style 14: To Apply Classy Style Type 2

This style will make the chart more beautiful, like below.

Chart Style 14

Style 15: To Apply Increased bar without Gridlines

This style will remove gridlines but increase the width of the column bars.

Chart Style 15

Style 16: To Apply Intense Effect to the Column Bars

This style will apply the Intense Effect for the column bars.

Chart-Style 16

Things to Remember

  • Each style is different from each other.
  • Always chose simple styles.
  • Never go beyond fancy styles, especially in business presentations.

Recommended Articles

This has been a guide to Change Chart Style in Excel. Here we discuss step by step how to change the chart style in excel along with examples & a downloadable excel template. You may also look at these useful articles on excel –

  • Animation Chart in Excel
  • Table Styles in Excel
  • Add Filter in Excel
  • Tornado Chart in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Change Chart Style Excel Template

Special Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More