Course Content

Course Content

Types of Chart in MS Excel

How To Create Charts In MS Excel

Till now we have learn that how we can create chart in MS Excel, but now we will see that how we can add or hide any particular element from chart.

As we select our chart, our data is also selected by which chart is created.

In MS Excel 2016 there are different kind of chart options as compared to previous Microsoft Excel versions like MS Excel 2007. Here on top right of chart we are given three different icons which are of Plus sign, Brush sign, and a Filter sign.

As soon as we click on Brush tool, we can see that there are different types of chart options available which shows us different format of our chart.

Now as we click on Plus sign, we can see on left side there is an pop up of Chart elements. It contains different options like Axes, Axis Titles, Chart Title, Data Labels, Data Table, Error bars, Gridlines, and Legends.

If we want any change in our axes, then we can double click on the data displayed and then Format Axis dialogue box will get opened from right side, which will give us different sizing options, color fill option etc...

Suppose we want to format any chart element then posting which we can do is double click on that particular element and perform any option which we want.

So this is so we can format any element from the chart.


  • Bar Chart.
  • Line Chart.
  • Pie Chart.
  • Maps.
  • Density Maps.
  • Scatter Plot.
  • Gantt Chart.
  • Bubble Chart.

Line graphs, bar graphs and histograms, pie charts, and Cartesian graphs are arguably the four most popular. They are commonly used for, and are best for, a variety of purposes.

Chart patterns are divided into three categories by technical analysts: a classic chart pattern Patterns with a symbiotic relationship. Pattern of a candlestick.

Visual representations of spreadsheet data are charts and graphs. These images aid in the comprehension of worksheet data by highlighting patterns and trends that are difficult to spot in the data. Experimenting with the many charts in Excel is the greatest method to learn about them. Open a data-filled Excel spreadsheet.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere