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.

In this post we show you how to create a Bar Graph or Column Chart in Excel. Bar graphs could be both 2-D or 3-D depending on the editor you use.

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.

It is straightforward to create a bar graph or chart, Line chart, etc. in an Excel spreadsheet. When you create a graph or chart, it fetches data from the selected cells.

You can easily make a pie chart in Excel to make data easier to understand. The process only takes 5 steps.

I just tried this. Select all the data you want to have graphed, click on Insert, pick line graph, and choose which one you want. Excel (2007) automagically grouped date and time on the X axis.