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

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.

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.