Excel Tutorial Making Graphs

Creating a graph in excel is easy.

Excel tutorial making graphs. Its app icon resembles a green box with a white x on it. Sometimes if you do not assign the right data type to your columns in the first step the graph may not show in a way that you want it to. Create the basic excel graph with the columns selected visit the insert tab and choose the option 2d line graph. Its a white box in the upper left side of the window.

Bar displays one or more sets of data using vertical bars. You can use data labels to focus your readers attention on a single data series or data point. You will immediately see a graph appear below your data values. Looking at a graph helps us analyze various metrics just by taking a glance at it.

Excel makes it easy to swap out the type of chart youre usingeven after its created. The graph below depicts the sum of active covid cases that are grouped by who region. To do so click within the chart go to the chart design tab find the change chart type button and select the type of chart you want to swap to. Click the button on the right side of the chart click the arrow next to legend and click right.