How To Use Excel Graphs

Click on the navigation down arrow available besides the chart options it will open up several chart options.

How to use excel graphs. You will see it transform into a tiny arrow pointing downwards. Highlight the cells that contain the data you want to use in your graph by clicking and dragging your mouse across the cells. The stacked column chart is useful when you want to compare multiple groups as well as series within the groups. You should see a graph window pop up in the middle of your excel window. A bar graph resembles a series of vertical bars.

This is how you can plot a simple graph using microsoft excel. If so hold down the ctrl key while you select the cells you want. To create a chart follow these steps. Click on chart title and add the title as country wise sales for this chart also select the last option available namely series sales amount this allows you to make customized changes into series data numeric values in this case. You may need to select a range of cells that don t touch each other noncontiguous for step 1.

In the charts section of the insert toolbar click the visual representation of the type of graph that you want to use. Select a graph type. Once the text is highlighted you can select a graph which excel refers to as chart. A drop down menu with different options will appear. Select the data to include on the chart.

In the above stacked column chart we can directly compare q1 q2 q3 and q4. For a graph to be created you need to select the different data parameters. Hover your mouse cursor over a line graph template in the drop down menu to see what it will look like with your data. Then click the type of graph you wish to use. When this happens click on the cell a and the entire column will be selected.

Learn how to add a linear trendline and an equation to your graph in excel. 8 click a graph style. Using excel to calculate and graph correlation data calculating pearson s r correlation coefficient with excel creating a scatterplot of correlation data with excel. To do this bring your cursor over the cell marked a. In this video i show you how to make a line graph in excel.