If you are a business owner you should know about how to make a graph in excel. Excel is one of the most used software tools in the whole world. Even if you are a student, accountant, businessman or any occupation that requires you must be used this software tool.
It is impractical to do statistics without graphs and charts, and Microsoft Excel is one of the tools which have plenty of options when it comes to the graph. Microsoft Excel accumulates data, it also discloses the outlying of your data.
The advantage of using Microsoft Excel Is that it can be created rate of the quantity it needs to represent and display numerous classes of data in a single graph. In which we also put a large amount of visual form of data for better understanding. So for that, we have made a complete tutorial of how to make a graph in excel that guides you.
This tutorial is going to help with how to make a graph in excel.
HOW TO MAKE A GRAPH IN EXCEL?
When it comes to how to make a graph in excel. There are five simple steps in which you will know how to make a graph in excel? So follow up these steps.
STEP NO 1: Entering Data
Excel sheet consists of rows and columns. So Insert your data into the rows and columns.
STEP NO 2: Choosing Range
After inserting your data, select the range into which your graph and chart are to be made.
You can do this by highlighting the data range from which you wanted to make graphs and charts, by clicking and dragging your mouse across the cells. Your cell range is now highlighted. Now selects the type of graph you need.
STEP NO 3: Creating the Chart
After selecting the data range, go to the insert ribbon and click on the Suggested Charts icon, which is given above.
Choose the type of chart you need to make, which will depend upon the type of data you have.
For this tutorial, we make a simple line chart
STEP NO 4: Editing the Chart
After the creation of graphs and charts, you need to edit them.
This includes the changing title, name of values on the X and Y axis and changing color and style, etc.
You can do this by adding more chart elements by clicking on the + icon on the right top side of the chart. It opens a menu of various chart elements. choose one option which you want.
STEP NO 5: Formatting the Chart
Here you can design and format the chart. Design can be chosen by clicking on the brush under the + button.
Right-click then you get formatting option and formatting panel will open on the right side of the screen.
SOME TIPS REGARDING HOW TO MAKE GRAPHS IN EXCEL?
. Make charts and graphs simple.
. Use sensibly text
. Choose appropriate themes.
.Place elements only if needed.
So in order to make your graphs and charts look better to follow these few tips for how to make a graph in excel?
HOW TO MAKE A LINE GRAPH IN EXCEL?
Now you know how to make a graph in excel lets find out about linear graph. A line graph is the best to show up their continuous data over time. These lines connect each data point which visualizes that the values have been increased or decreased during the whole period.
Now here you can follow these four steps in which you know: How to make a line graph in Excel? OR how to make a single line graph in excel?
STEP NO 1: Open the Excel spreadsheet with the data you want to choose in your line graph. Make sure your chosen data must be correct
STEP NO 2: Click and drag your cursor and highlight all the rows and columns with the written data which you want to include in the graph.
STEP NO 3: Click on the Insert tab at the top of the window, and then click on the line graph icon. (it looks like two zigzagging lines).
STEP NO 4: Select the chart style which you prefer by the pop window by clicking on it.
The chart will be created automatically. Name it and drag it where you needed it.
Another few knowledge about excel How to Remove Duplicates In Excel
HOW TO MAKE A LINE GRAPH IN EXCEL WITH MULTIPLE LINES?
If you want multiples lines in your line graph then your data needs to be in multiple rows. Instead of having one row you have to highlight the two rows of information. Then click on the INSERT line chart will like below.
HOW TO MAKE ALINE GRAPH WITH TWO SETS OF DATA?
For making your line graph with two sets all you have to do is follow these simple steps on how to make a line graph with two sets of data? SO, it is also simple as to how to make a graph in excel.
- Select the two sets for which you want to make a line graph.
- Click on the Insert tab and then select “Recommendation Charts” from the chart group.
- Choose “All Charts” choose the “Combo” option from chart type then select the “Clustered Column-Line”, which subtype of line chart by default.
- Choose your own type of chart you want for two sets of data. Now select the “Secondary Axis” box of your data, which you want to move to the secondary axis.
- Now click on “OK”
HOW TO MAKE A BAR GRAPH IN EXCEL?
For making a bar graph in excel follow these four steps then you will know how to make a bar graph in excel?
STEP NO 1: Highlight your data that you would like to use for the bar chart.
STEP NO 2: Select the Insert tab from the toolbar option at the top of the window. Click on the bar chart from charts group under the drop-down menu
STEP NO 3: Now you will see a bar chart that appears in your spreadsheet with horizontal bars.
STEP NO 4: So now let’s update the title of our bar chart.
Enter the title of your choice. In this tutorial, we have mentioned the title “Product Life”.
HOW TO MAKE A DOUBLE BAR GRAPH IN EXCEL?
Now follow these four steps then you will know how to make a double bar graph in excel?
STEP NO 1: Open you Microsoft Excel
STEP NO 2: Enter the name of your data on which you want your double bar graph, like starting with the cell B1 and continuing to the right of that cell.
STEP NO 3: Type the name of that two categories for which you want a double bar graph like the track cells are from A1 AND A3. These labels will be located on the right top of the bar graph. Each of these categories will differentiate by their two different colors like RED & BLUE
STEP NO 4: Choose Insert tab at top of the screen. Click on the Bar button which is in the charts area of ribbon .choose any chart of your choice, I am choosing here the “Clustered” bar chart option. As on the other hand, I choose the “Stacked” option. Now here your double Bar will be created on your spreadsheet.
HOW TO MAKE A GRAPH WITH TWO Y-AXIS IN EXCEL?
Following the steps which are given below will show you how to make a graph with two y-axes in excel. So let’s start these steps. Few steps are the same as how to make a graph in excel.
STEP NO 1: Select the data range which you have and insert a chart first by clicking the insert button and selecting a chart you need from the chart group.
STEP NO 2: Right-click on the chart in the column and select format data series in the menu.
STEP NO 3: From the format data series dialog box you will check the secondary axis in the plot series on section, and click the close button.
STEP NO 4: Right-click on the red column in the chart, choose the change series chart type
STEP NO 5: In the change chart type dialog box, click on the line in the left side .and choose your favorite line chart
STEP NO 6: Click on OK to close the dialog box. And now see the two y-axes inserted in your spreadsheet.
CONCLUSION: HOW TO MAKE A GRAPH IN EXCEL?
So for all the question that comes in your mind related to how to make a graph in excel? Or how to make a double bar graph for all these queries read this article for complete guidance.
Leave a Reply