How to Make a Tally Frequency Chart

by Emily Ediger
Siri Stafford/Photodisc/Getty Images

Microsoft Excel spreadsheets allow you to store and present information in a variety of ways. If you want to visually display a tally frequency, you can create a chart in an Excel spreadsheet. Excel provides many tools for customizing your charts. You can change the font, border and background formats to create a professional and visually appealing chart. Charts help you communicate information by summarizing data and displaying it in a recognizable way.

Step 1

Create a new Microsoft Excel spreadsheet or open an existing spreadsheet with tally frequency information. Label column A with a description of your categories. For example, if you tallied the types of products that were sold, you would label column A as "Product Type" and your categories might be "beverage," "food" and "frozen."

Step 2

Label column B as "tally frequency." This column will hold the number of instances that is associated with each category. In the product example, if you sold 50 frozen items you would like "50" in column B next to "frozen."

Step 3

Highlight your data and select the "Insert" tab of the ribbon at the top of the page. Select the "Column," "Pie" or "Scatter" to create a chart for your tally frequencies. Column charts show counts, pie charts express percentages and scatter plots display points on a graph.

Select "Layout" from the ribbon to add titles, labels and custom formats. Select the "Display" and "Format" tabs to change the chart colors, graph lines, and style of the chart. Save the spreadsheet by selecting the "Save" icon in the upper left-hand corner of the screen.


  • If you add new categories and tally frequencies, you can update the chart by clicking the "Select Data" button on the "Design" tab of the ribbon. Under "Chart Data Range" select the new parameters of your data.


Photo Credits

  • Siri Stafford/Photodisc/Getty Images

About the Author

Emily Ediger began writing professionally in 2007. Her work includes documenting technical procedures and editing event programs. Her expertise lies in technology, interactive learning and information retrieval. She holds a Bachelor of Arts in English from Portland State University.

More Articles