Here’s how to make a bar graph in Excel.
To make a bar graph, highlight the cells you want to graph.
verify to include both theLabelsand theValues, as well as theHeader.
Next, select theInsertmenu.
Under theChartsgroup in the menu, snag the dropdown next to theBar Chartsicon.
However you’re free to find2-D Barand3-D Barin all Excel versions under this list.
At the bottom of this list, click onMore Column Charts.
In the pop-up window, selectBarfrom the left pane.
Here you’ll see 6 bar charts to choose from.
When you clickOK, the chart will appear in the spreadsheet.
Initially, every bar will have the same color.
In theFormat Data Seriespane, select theFill & Lineicon (paint can) and underFillselectVary colors by point.
you might edit the title simply by selecting the Graph title and re-typing a new one.
You’ll see those changes reflected automatically in the bar graph.
This is a great way to identify trends over time for multiple items.
The procedure below will produce a comparison chart with multiple clustered bars for each label over time.
To build a Clustered Chart, select all the data in your spreadsheet.
check that to include allLabels, allcolumnsof data, and allHeaders.
SelectTitlefrom the menu and in theChartssection of the ribbon, select theBar Chartsicon.
In the drop-down menu, select either the2D Baror3D Barclustered chart.
This will place the clustered graph in your Excel spreadsheet.
You’ll notice that for each student’s name, a bar of a different color represents each column.
The column header shows up at the bottom of the chart to identify what each color represents.
you’re able to changeColors,Borders, and more.
you’ve got the option to add additional columns of data after the graph is in the spreadsheet.
To do this, opt for bar graph and the cells the graph contains will highlight.
When you’re done, you’ll see a third bar added to every cluster in the bar graph.
This means you’re not stuck with fixed data when you make a bar graph in Excel.
Add data however often you’re gonna wanna and the graph will update automatically.
