A pie chart with a bar of data showing a football match between two teams is just like the one below.
You can use this method for many different types of pie charts, including football, soccer, baseball, tennis, and even the Olympic Games.
Here are the steps you’ll need to follow: Create the chart and the bar.
If you don’t already have an Excel spreadsheet open, download the free version from Microsoft.
Select the team that you want to create the pie chart on.
Click “create chart” to create a pie chart.
Select a cell in the chart.
Then click “next” to add a cell to the chart for later analysis.
If your chart doesn’t show up immediately, the chart may have been created on another computer.
Select “Pie chart” from the left menu.
Make sure the pie charts tab is selected.
Under the “Pie Chart” column, click “Show Data” to display the data you’ve just created.
If there’s an “Excel” button in the top right corner, click it.
On the “Chart” page, click the “Next” button to create your chart.
You’ll be taken to a page with a blank line, so click “OK” to save the chart to your Excel spreadsheet.
The chart will automatically populate, but you can click “Open” to see the data.
Next, create a column of data to visualize.
On a standard chart, you’ll just add a horizontal line that goes up to the top.
But on a pie-chart, you can use a vertical line to separate the data points.
Choose a line that looks like this: “This column will be used as the baseline for the next graph.”
Add a horizontal bar to the bottom.
Click the “Add” button.
Excel will prompt you to name the column “Baseline” (or “Basement”).
This is a space-separated list of values for each column.
You may have to use the comma symbol (:) to separate values for the horizontal bar and the vertical bar.
On your first sheet, you should have a column with values for: “B” (battery), “A” (attempts scored), “B+” (ballpark average), “C” (average), “D” (drive rate), “E” (extra-base hit), “F” (fielding average), and “G” (goals scored).
Next, add a line for each player.
You probably won’t want to put the names of all of the players on a line, but for a few players, you might want to use a line like “A+” to separate each player’s stats.
You will probably need to add another column, too.
If the baseline column doesn’t have a line in it, select it and choose “Next.”
The next line will appear, labeled “Player Stats”.
Choose the column you just added and click “Next”.
Excel will add an “A”, “B”, “C”, or “D”, as appropriate.
If Excel isn’t doing this automatically, you may have used the default “A +” or “B +” column values instead.
The data will be automatically added.
If that’s not enough, click on “Save” and your pie chart will be saved to your spreadsheet.
Repeat this process for the other columns, or for the chart as a whole.