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 customising 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 summarising data and displaying it in a recognisable way.
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."
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."
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 colours, 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.
Tips and warnings
- 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.