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

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.

How to Make a Graph With Months in Excel. When you create a graph that includes dates, Excel 2013 automatically spaces the data in chronological order.

Are you constantly changing your Excel chart's data range as new information becomes available? Mary Ann Richardson shows how to set up the chart to automatically update as you add new rows of ...

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

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.

If you need to create a Line Chart and Scatter Plot in Excel, read through this article. We have also explained which one is right for you.

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.