How To Use Excel To Make A Graph

Creating a graph in excel is easy.

How to use excel to make a graph. The dataset that we will be using comprises the latest data on coronavirus cases country wise. In this example we re comparing the profit of five different products from 2013 to 2017. Change the size of your chart s legend and axis labels. Who region of every country. You should see a graph window pop up in the middle of your excel window.

To create a chart follow these steps. Take a look at the second chart you will see the title. For a graph to be created you need to select the different data parameters. Click and drag the second chart to separate it go to fill and remove the grid lines. Enter data into a worksheet open excel and select new workbook.

On the top panel in excel the chart tools section will. You will see it transform into a tiny arrow pointing downwards. However if you want your data visualization to be compelling to the readers you must also know how to edit your graph. It may not be in line with the first graph so kindly remove the title from the second graph go to the text fill under the formating option and change to no fill 12. Change the y axis measurement options if desired.

Hover your mouse cursor over a line graph template in the drop down menu to see what it will look like with your data. When this happens click on the cell a and the entire column will be selected. To get the desired chart you have to follow the following steps select the data you want to represent in graph click on insert tab from the ribbon click on the column chart drop down button. Enter your data into excel. It can be done in several ways.

You can also hover over a format to see a preview of what it will look like when using your data. It has records of. In your selected graph s drop down menu click a version of the graph e g 3d that you want to use in your excel document. How to make a graph in excel. Choose one of nine graph and chart options to make.