How to Make a Tally Graph in Microsoft Excel

Last Updated: Feb 12, 2024 by

Tally charts, also known as frequency charts, are a useful way to visually represent data. They are commonly used in classrooms to teach students how to collect and organize data. However, tally charts can also be used in business settings to track sales, customer feedback, and other important information. In this article, we will show you how to make a tally graph in Microsoft Excel, so you can easily create and analyze your own data.

Setting Up Your Data

Before you can create a tally graph, you will need to have your data organized in a table in Microsoft Excel. Each column should represent a different category or variable, and each row should represent a different data point. For example, if you are tracking customer feedback, your columns might include “Satisfied,” “Neutral,” and “Dissatisfied,” and your rows might represent different customers.

Creating the Tally Chart

Once your data is organized, you can easily create a tally chart in Microsoft Excel. First, select the cells that contain your data. Then, click on the “Insert” tab and select “Bar Chart” from the “Charts” section. A drop-down menu will appear, and you can choose the type of bar chart you want to create. For a tally chart, select the “Clustered Bar” option.

Customizing Your Tally Chart

After you have created your tally chart, you can customize it to fit your needs. You can change the colors, add labels, and adjust the size and position of the chart. To add labels, click on the chart and then click on the “Chart Elements” button that appears on the right side. From there, you can select which elements you want to add, such as data labels or a chart title.

Tips for Creating a Tally Graph in Microsoft Excel

  • Use different colors for each category to make the chart more visually appealing and easier to read.
  • Add a legend to your chart to explain what each color represents.
  • Use a stacked bar chart to compare the total number of data points in each category.
  • Use a clustered bar chart to compare the number of data points in each category for different time periods or groups.

Common Mistakes to Avoid

  • Not organizing your data properly before creating the chart.
  • Using too many categories, which can make the chart cluttered and difficult to read.
  • Not labeling your chart or including a legend, which can make it confusing for others to interpret.


Tally charts are a simple yet effective way to represent data in a visual format. By following these steps, you can easily create a tally graph in Microsoft Excel and customize it to fit your needs. Whether you are a student learning about data collection or a business owner tracking important information, tally charts can be a valuable tool in your data analysis toolkit. Have you used tally charts in your work before? Share your tips and experiences in the comments below.

Gulrukh Ch

About the Author: Gulrukh Ch

Gulrukh Chaudhary, an accomplished digital marketer and technology writer with a passion for exploring the frontiers of innovation. Armed with a Master's degree in Information Technology, Gulrukh seamlessly blends her technical prowess with her creative flair, resulting in captivating insights into the world of emerging technologies. Discover more about her on her LinkedIn profile.