If you are a business owner you should know 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 from 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.
- 1 HOW TO MAKE A GRAPH IN EXCEL
- 1.1 HOW TO MAKE A GRAPH IN EXCEL
- 1.2 HOW TO MAKE A LINE GRAPH IN EXCEL?
- 1.3 HOW TO MAKE A DOUBLE BAR GRAPH IN EXCEL?
- 1.4 HOW TO MAKE A GRAPH WITH TWO Y-AXIS IN EXCEL?
- 1.5 CONCLUSION:
- 1.6 Related
HOW TO MAKE A GRAPH IN EXCEL
The advantage of using Microsoft Excel Is that it can be created a 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 that guides you.
This tutorial is going to be helpful with how to make graphs 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 on these steps.
STEP NO 1: Entering Data
Excel sheets consist 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 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 the formatting option and the 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 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 let’s find out about linear graphs. Line graphs are 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.
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 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 the 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”.
Also read: How to Lock Cells in Excel
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 your Microsoft Excel
STEP NO 2: Enter the name of your data on which you want your double bar graph, like starting with 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 the Insert tab at top of the screen. Click on the Bar button which is in the charts area of the ribbon. choose any chart of your choice, I am choosing here “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 same as the 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 on 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.
Now you have learned to make graphs in excel. You can make all types of graphs easily. It’s time to practice it, you can practice it online at the office.com site.
HOW TO MAKE A GRAPH IN EXCEL?
So for all the question that comes in your mind related to how to make a single graph in excel? Or how to make a double bar graph for all these queries read this article for complete guidance.