Skip to main content

How To Make A Graph or Chart In Excel

Easy way to create a simple chart in Excel.


The chart provides you the easy way to understand huge data, create a good comparison, and a relationship among different series. In the beginning, you can practice with simple data like write some names and put any value into the next column and create a graph.  In this article, we will learn about a simple graph, which covers the basic and important necessary points to create a simple graph.  In a graph, we must have at least two axis x and y.

Let suppose we have data with student's marks of different subjects. We can create a simple chart which shows name wise mark wise comparison among the staff.


See the image below to get a good understanding of graphs.


Graph
Image: 1 - Simple Graph


Steps - How to make it easily.. Follow the steps.
First select the data on which you want to apply the graph.
Second Go To : Insert or Use Short cut key : Alt + N
Third: Select the graph as you required. Insert Bar or Pie chart. We have selected a simple bar chart.
Once you select the bar chart it will look like the same chart as image: 1 above.

In order to get a superfast chart use the below defined method or short cut method.


If you want a bar chart with in a minute .....
Select the data on which you would like to apply the chart...
Press F11 
One graph will  create in the next sheet..

Graph are very easy and intrusting to make our reporting fantastic, even if you are good in MS Excel, you must understand graphs. It makes your dashboard very attractive and professional. We have provides you the best way to learn the graph very easily in just few minutes. 

My suggestion is to use the same data and prepare the simple graph to make it clear...

Please like and comment..


Comments

Popular posts from this blog

Top 10 Job Oriented Certificate Courses

Hello Friends and students. Life is very fast these days and we want some shortcut to become successful in our life. Maximum students want to get a job as soon as possible after completing their studies. Here we will suggest the top 10 job-oriented certificate courses. 1 - Project Management Professional (PMP) Certification: Globally, industries greatly value project management professional certification. It gives you the ability to manage projects successfully, including team leadership, planning, execution, and monitoring. After this course, you can handle big projects or you can assist the senior also. For All Details Click Here 2 - Certified Data Scientist: Making informed business decisions requires data science. This certification prepares you to analyze and interpret complicated data by covering statistics, machine learning, data visualization, and programming abilities. Data scientist is the most demanding course during this period. If you are good to play with huge databases a...

How To Use "LEFT" & “ RIGHT" Formulas in MS Excel.

Uses and explanation of "LEFT" & “ RIGHT Formulas. MS Excel formulas: Easiest way to understand Syntax and usage : Formula:  A: "RIGHT”     B:   “LEFT” =RIGHT(Text,[num_chars]) Explanation:    RIGHT formula is used to split the value inside the cell. In a cell we have a name like "John Abraham", but we don't need the full name, as per client requirement, we want only last name from the tab. In this case, we can use Right formula in MS Excel. Example:   Let suppose we have the name “Mark Henry” in a cell A:1. We would like to take only “Henry” from the cell. See below, how can we pull the last name by the RIGHT formula.  =RIGHT ( E9 , 6 ) You can see in the above table that we can separate Hanery name with using RIGHT formula. Name: Mark Hanery. Query:  We want to separate the last name only.  Formula = Right(E9,6)  Result: Hanery E9 is the cell reference and 6 is the number of...

What is Project Management Professional Certification

The Project Management Professional (PMP) certification is one of the most widely recognized and respected credentials in the field of project management. It is offered by the Project Management Institute (PMI), a globally recognized professional organization for project management practitioners. The PMP certification signifies a high level of expertise and proficiency in project management principles and practices. Below are the full details about the PMP certification: Eligibility Requirements: To be eligible for the PMP certification, candidates must meet certain educational and professional experience criteria: 1 - Educational Background: A four-year degree (bachelor's degree) or global equivalent. Minimum a high school diploma, associate's degree, or global equivalent) in conjunction with additional project management experience. 2 - Project Management Experience: With a four-year degree: A minimum of three years of unique non-overlapping professional project management ex...