MS Excel Course > Charts

Creating Charts in MS Excel

288.3k
Overview

How to create a chart in MS Excel

Now we will see that we can create chart in MS Excel.

Suppose if you want to show any particular information in comparison form then we can create the chart for better understanding.

The simplest way to create a chat is first of all, we will select the data which we want, and after that press 'Alt+F1' key, as soon as we press the key a chart will be inserted according to our selected data and also 'Chart tools' will be added in ribbon section.

Chart tool consists of two things that is Design and Format.

Now we will select the data and then go to INSERT tab and then in that we will see an option of Recommended Charts. As soon as we open it we will see different kind of recommended charts like clustered column, clustered bar and many others, we can choose any chart according to our requirement.

Now if we want to display our chart in different sheet, then we will first select the data which we want in chart form and after that we can press 'F11' button from our keyboard which will create a different sheet named as 'Chart1' and our chart will be automatically inserted there.

Now if we have decided that we want our chart to be in Bar form, than we can select our data a d after that from INSERT tab Chart column we can select our requirement chart form.

See More

There are various types of charts that you can create in Excel - bar charts, line graphs, pie charts, etc. The type of chart you choose will depend on the type of data that you want to represent and what kind of information you want your audience to take away from it.

The following steps will help you create a basic bar chart in Excel:

  •  Create a new sheet in Excel and select the cells where you want your chart to appear
  • Select "Insert" from the menu at the top left corner

  • A column chart is a simple way to represent data visually, with the height of each column representing a different value. The columns are drawn side-by-side, with the width of each column proportional to the value it represents.
  • A bar chart is a visual representation of data using rectangular bars of varying lengths to show how much or what percentage each item contributes to the whole.

In order to create a pie chart, you need to open an Excel spreadsheet and insert your data into cells as shown below:

  • Click on cell A3 and enter your data into this column.
  • Select cells A3 through A6 by clicking on them with your mouse and dragging them down so that they are below cell B3.
  • Select cell B3 by clicking on it with your mouse

Learner's Ratings

4.4

Overall Rating

  • 68%
  • 20%
  • 6%
  • 3%
  • 3%

Reviews

R
RESHMI KUMARI
5

its very useful for us

S
SHIVAM TIWARI
5

Formula wala pura uper ja rha

N
Navjeet Kaur
4

The theory is really good, but practice sheets must also be provided so that we can practice hand to hand. Excel is all about practice more than theory.

A
Aman kesarwani
5

Hi. Please mujhe free mai certificate dedo please 😭😥🙏🙏

D
DABLOO Kumar
5

good and very suficient course

S
Saurabh Kumar
5

very useful super

A
Ankit Chaturvedi
5

It is good for New Learner and need to add sum more topics. Overall it is good.

1
18-Roshan punjaji Mahajan
5

very good course

S
SHREYA AGARWAL
4

this course is so wonderfully made ! i have learnt so much from this :)

S
Suzen Kumar Mohanty
5

vergoodcourse

Show More
Recommended Courses
Course Content

  1. Menu in Excel
    4m 57s
  2. How to use LearnVern
    3m 20s
  3. Quick Access Toolbar
    6m 21s
  4. Formula Bar in Excel
    2m 5s
  5. Status Bar in MS Excel
    5m 23s
  6. Navigation in MS Excel
    3m 4s
  7. Shortcuts in MS Excel
    4m 15s
  8. Format Painter in MS Excel
    2m 29s

  1. Data Entry in MS Excel
    5m 9s
  2. Autofill in MS Excel
    5m 42s
  3. Data Entry for Date-Time in MS Excel
    5m 46s
  4. Undo-Redo in MS Excel
    5m 32s
  5. Comments in MS Excel
    4m 1s
  6. Saving File in MS Excel
    4m 27s

  1. Creating Formula in MS Excel
    7m 45s
  2. Copy Formula in Excel
    3m 35s
  3. Till Date Formula in MS Excel
    3m 36s
  4. Pct Calculation in MS Excel
    5m 20s
  5. Absolute in MS Excel
    6m 10s
  6. Sum Average in MS Excel
    6m 5s
  7. Other Common Functions In MS Excel
    7m 52s

  1. Formatting Fonts in MS Excel
    3m 49s
  2. Adjusting Rows & Columns in MS Excel
    4m 2s
  3. Alignment in MS Excel
    7m 10s
  4. Formatting Borders in MS Excel
    2m 55s
  5. Formatting Numbers in MS Excel
    7m 23s
  6. Formatting Date-Time in MS Excel
    10m 47s
  7. Conditional Formating in MS Excel
    10m 38s
  8. Formatting Tables in MS Excel
    8m 43s
  9. Formatting Shapes in MS Excel
    7m 5s

  1. Resizing Row & Column in MS Excel
    7m 18s
  2. Hide-Unhide Row and Column in MS Excel
    5m 29s
  3. Copy, Move, Insert Data in MS Excel
    5m 37s
  4. Find Replace in MS Excel
    6m 35s

  1. Printing in MS Excel
    6m 35s
  2. Page Break Preview in MS Excel
    5m 20s
  3. Page Setup in MS Excel
    4m 58s

  1. Creating Charts in MS Excel
    7m 13s
  2. Types of Chart in MS Excel
    5m 40s
  3. Formatting Charts in MS Excel
    6m 36s
  4. Chart Elements in MS Excel
    7m 44s
  5. Sparklines in MS Excel
    8m 1s

  1. Freezing Workbook in MS Excel
    7m 28s
  2. Splitting Sheets in MS Excel
    6m 39s
  3. Outline in MS Excel
    7m 3s

  1. Manage Multiple Workbook in MS Excel
    6m 48s
  2. Working with Sheets in MS Excel
    4m 42s
  3. Copy & Delete Sheets in MS Excel
    6m 36s
  4. Use of Formula in Worksheet
    9m 22s
  5. Edit Links in MS Excel
    10m 43s

  1. If Condition in MS Excel
    6m 26s
  2. VLOOKUP in MS Excel
    6m 2s
  3. VLOOKUP Exact in MS Excel
    4m 10s
  4. COUNTIF in MS Excel
    4m 25s

  1. Protecting Sheets in MS Excel
    4m 55s
  2. Securing Workbook in MS Excel
    5m 45s
  3. Password to Workbook in MS Excel
    2m 21s
  4. Sharing Workbook in MS Excel
    3m 10s
  5. Track Changes in MS Excel
    5m 33s

  1. Sorting in MS Excel
    6m 38s
  2. Subtotals in MS Excel
    7m 26s
  3. Filter in MS Excel
    5m 32s
  4. Split Data in MS Excel
    4m 21s
  5. Flash Fill in MS Excel
    3m 41s
  6. Remove Duplicate in MS Excel
    2m 33s
  7. Data Validation in MS Excel
    6m 50s

  1. Creating Pivot Table in MS Excel
    11m 11s
  2. Manipulating Pivot Table in MS Excel
    8m 29s
  3. Adding Slicers in MS Excel
    4m 36s
  4. Other Grouping of Pivot Table in MS Excel
    4m 40s

  1. Macro in MS Excel
    7m 29s

  1. Excel Assignment Q-1
    1m 11s
  2. Excel Assignment Q-2
    21s
  3. Excel Assignment Q-3
    34s
  4. Excel Assignment Q-4
    51s
  5. Excel Assignment Q-5
    48s
  6. Excel Assignment Q-6
    37s
  7. Excel Assignment Q-7
    47s
  8. Excel Assignment Q-8
    45s
  9. Excel Assignment Q-9
    37s
  10. Excel Assignment Q-10
    33s
Enroll For Free