Nope, Excel won’t allow it. Also, moving the line graph to the right would defeat the purpose of presenting the cumulative frequency in the graph. This kind of presentation is actually called “Pareto Chart” used for quality control in companies and businesses around the world.
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.
![How To Make A Frequency Graph In Excel For A Mac How To Make A Frequency Graph In Excel For A Mac](/uploads/1/2/5/8/125822934/480136747.jpg)
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.
Tip
- 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
More Articles
Did you know that you can use pivot tables to easily create a frequency distribution in Excel? You can also use the Analysis Toolpak to create a histogram.
Remember, our data set consists of 213 records and 6 fields. Order ID, Product, Category, Amount, Date and Country.
First, insert a pivot table. Next, drag the following fields to the different areas.
1. Amount field to the Rows area.
2. Amount field (or any other field) to the Values area.
3. Click any cell inside the Sum of Amount column.
4. Right click and click on Value Field Settings.
5. Choose Count and click OK.
6. Next, click any cell inside the column with Row Labels.
7. Right click and click on Group.
8. Enter 1 for Starting at, 10000 for Ending at, and 1000 for By.
9. Click OK.
Result:
To easily compare these numbers, create a pivot chart.
10. Click any cell inside the pivot table.
11. On the Analyze tab, in the Tools group, click PivotChart.
The Insert Chart dialog box appears.
12. Click OK.
Result: