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.
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
Post a Comment