If you're looking for the perfect way to visualize the stats and data that you have compiled, Google Sheets and Microsoft Excel can help. We'll show you how.

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.

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

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.