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 Blockchain Technology?

Blockchain Technology Blockchain technology is a decentralized digital ledger that enables secure transactions and storage of data. It is essentially a chain of blocks, where each block contains a record of transactions that are verified and added to the chain by a network of computers. Once added to the chain, these records cannot be altered or deleted, ensuring the integrity and immutability of the data. This technology is based on cryptography, distributed computing, and game theory principles, making it highly secure and transparent. It eliminates the need for intermediaries or third parties, reducing transaction costs and increasing efficiency. Blockchain technology has a wide range of applications, including but not limited to, cryptocurrency transactions, supply chain management, voting systems, smart contracts, and digital identity verification. Its potential for disruption is enormous, and it is considered to be one of the most significant technological innovations of the past...