Excel automatically inserts the graph, but it has no labels. Review the new green "Chart Tools" tab and ribbon at the top of the screen. If you don't see them, click the chart to enable them.

Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.

Excel can do more than just render typed numbers in tables of cells. It can take two columns of numbers and show a pictorial representation of how they relate to each other through a graph.

Graphs in Excel help break down your data into an easily digestible format. Here’s how to make a graph in Microsoft Excel.

You can make a bar graph in Excel by first selecting the range you want to depict, and then using the dropdown menu to select the desired chart.

You can make a line graph in Excel in a matter of seconds using data already entered into the spreadsheet.

Figure A You need the People Graph add-in for Excel. To populate an Excel people chart, you need some data. Figure B shows a simple data set along with the dummy chart.