How to Make a Tally Frequency Chart

by Emily Ediger

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.

Video of the Day

Brought to you by Techwalla
Brought to you by Techwalla

More Articles