How to Make a Tally Graph in Excel. Display your tally information in a visually appealing way with Microsoft Excel graphs. ... Label column B as "Count" to store the tally totals.

If you want Excel to automatically count up each use of a certain phrase, you can use the "COUNTIF" function for this. ... and Excel will be able to immediately tally each use of that phrase.