How To Make A Pie Graph

Why Can’t I Insert A Pie Chart In Word

You might also be experiencing this issue because of add-ins or software that is interfering with Office programs. To check if this is the case, we recommend that you perform a clean startup to your computer and then start Word to see if you can insert a pie chart.

So, if you must use a pie chart, try to abide by these rules:

How To Create A Pie Chart In Excel In 60 Seconds Or Less

At the beginning of 2021, I was tasked with an assignment: Create a pie chart showcasing which types of content performed best on the Marketing Blog in 2020.

The question was an undeniably important one, as it would influence what types of content we wrote in 2021, along with identifying new opportunities for growth.

But once I’d compiled all relevant data, I was stuck How could I easily create a pie chart to showcase my results?

Fortunately, I’ve since figured it out. Here, let’s dive into how you can create your own excel pie chart for impressive marketing reports and presentations. Plus, how to rotate a pie chart in excel, explode a pie chart, and even how to create a 3-dimensional version.

Let’s dive in.

How To Convert A Pie Chart To A Bar Of Pie Chart

If youve already created a Pie chart and now want to convert it to a Bar of pie chart instead, here are the steps you can follow:

Your chart should now get changed to a Bar of Pie chart.

You can continue to customize the chart as we explained in the previous sections of this tutorial.

In this tutorial, we showed you how to create a Bar of pie chart and how to customize it according to your requirements.

We also showed you how you can convert a regular Pie chart to a Bar of pie chart if you need to.

We hope this was useful.

Other Excel tutorials you may also like:

Don’t Miss: Américan Pie Band Camp Trailer

Creating Pie Of Pie And Bar Of Pie Charts

For example, if you have several companies that operate on the market, you canrepresent a part of every company on the market as a slice.

This data contains five slices that fall below 10%.

To make smaller slices more visible in a pie chart, Microsoft Excel provides thePie of Pie , and Bar of Pie chart sub-types.

Each of these chart sub-types separates the smaller slices from the main pie chart anddisplays them in a supplementary pie or stacked bar chart. To create a Pie of Pieor Bar of Pie chart, follow these steps:

1. Select the data range .

2. On the Insert tab, in the Chartsgroup, choose the Pie and Doughnut button:

Choose Pie of Pieor Bar of Pie

3. Right-click in the chart area. In the popup menu,select Format Data Series…

4. On the Format Data Series pane, inthe Series Options tab, select which data to display in the second pie :

There are several ways to choose which categories to display in the secondarypie or bar chart:

• Split series by Position
• Split series by Value
• Split series by Percentage Value
• Split series by Custom

You can then make any other adjustments to get the look you desire:

• Pie Explosion detaches the slice from the primary chart and moves itcloser to the secondary chart
• Gap Width controls the distance between charts
• Second Plot Size specifies the relative size of the second chart.

Pie Chart Pros And Cons

Although Pie charts are used a lot in Excel and PowerPoint, there are some drawbacks about it that you should know.

You should consider using it only when you think it allows you to represent the data in an easy to understand format and adds value for the reader/user/management.

Lets go through the Pros and Cons of using Pie charts in Excel.

Lets start with the good things first.

Don’t Miss: Peach Cobbler With Frozen Pie Crust

Benefits Of Using A Bar Of Pie Chart In Excel

By separating the smaller slices from the main pie, the Bar of pie chart lets you handle more categories in a pie chart, thereby simplifying a complex pie.

You can also use this as a tool to highlight the important portions of your pie chart.

The Bar of Pie chart is quite flexible, in that you can adjust the number of slices that you want to move from the main pie to the bar.

Besides this, the Bar of pie chart in Excel calculates and displays percentages of each category automatically as data labels, so you dont need to worry about calculating the portion sizes yourself.

Change The Labels Of A Pie Chart

By default, the SAS Pie Chart shows the category name and its frequency inside the chart. You can change this default behavior with the datalabelcontent and datalabellocation options.

The datalabellocation option defines where the labels are placed. You can use the keywords inside and outside. By default, SAS places the labels at the inside.

With the datalabelcontent option, you define what information the labels contain. You can use the following options:

• ALL: To show the category name, frequency, and percentage.
• STANDARD : The show the category name and frequency.
• NONE: To show nothing:
• : To show the category name and percentage.
• : To show the category frequency and percentage.

In this example, we will show the category name and percentage outside of the Pie Chart, see the SAS code below.

proc template define statgraph my_pie_chart begingraph entrytitle "Pie Chart of IRIS Data" layout region piechart category=Species /name="my_piechart"datalabelcontent=datalabellocation=outside discretelegend "my_piechart" /title="Species:" endlayout entryfootnote "Graph created: & amp SYSDATE9." endgraph end run proc sgrenderdata=sashelp.iris               template=my_pie_chart run 

Recommended Reading: Key Lime Pie On A Stick Florida Keys

How To Make A Bar Graph On Google Docs: A Step

If youre looking for an efficient way to organize information on Google Docs, theres no better method than using a chart type. Its quite easily done.

In this section, well show you how to make a bar graph on Google Docs successfully. Plus, youll learn to make a pie chart, a line chart, and a waterfall chart.

In this section, well show you how to make a bar graph on Google Docs successfully, and, as an added bonus, youll learn how to create a pie chart, line chart, and waterfall chart as well.

Before we delve into the steps, make sure youre signed in to your Google account.

Recommended Reading: The Key Lime Pie Company

Creating Exploding Pies And Exploding Slices

The exploded pie option can be easier to read if there are a lot of values in your data set. If you want to emphasise a particular value, use the exploding slice option.

There are a couple ways to create exploding pies and exploding slices.

2. Add the exploding pie after you create the chart. To create an exploded pie, click and drag any slice, and the chart will adjust.

3. To explode a single slice, click once on the pie to select it, click on the desired slice, and then drag it out of the pie.

Note: If the two clicks are too close together, the Format Data Point window will appear.

You May Like: Muslim Navy Bean Soup

Construction Of Pie Chart

Now we will discuss about the construction of pie chart or pie graph. Inbrief let us recall about, what is a pie chart?

The pie chart is a pictorial representation of data relative to a whole. Each portion in the circle represent an element of the collected data. The pie chart represents the composition of various elements in a whole. The total value of the pie chart is always 100%. Each portion in the circle shows a fraction or percentage of the total.

Pie chart is a circular graph which is used to represent data. In this :

Various observations of the data are represented by the sectors of the circle.

The total angle formed at the centre is 360°.

The whole circle represents the sum of the values of all the components.

The angle at the centre corresponding to the particular observation component is given by

If the values of observation/components are expressedin percentage,then the centre angle corresponding to particularobservation/component is given by

How to construct a pie chart?

Stepsof constructionof pie chart for a given data:

Find the central angle for each component using theformula given onthe previous page.

Draw a circle of any radius.

Draw a horizontal radius

Starting with the horizontal radius, draw radii, makingcentral anglescorresponding to the values of respective components.

Repeat the process for all the components of the givendata.

These radii divide the whole circle into varioussectors.

Thus, we obtain the required pie chart.

Example Of Data Structure

Data for a pie chart can be summarized in a table like the above, where the first column indicates a category, and the second the proportion, frequency, or amount of that category. Usually, the total does not need to be specified separately unless it is to be listed somewhere else on a generated figure. Alternatively, some tools can just work with the unaggregated data as in the below table, essentially performing the aggregation into the table above at time of pie chart creation.

Don’t Miss: Key West Key Lime Pie Company The Profit

Formatting Data For Pie Charts

Getting your data ready for a pie chart is simple.

Just make sure that your categories and associated values are each on separate lines:

In this example, well use the number of units sold for a range of products.

Weve put each category and value on a row, but you can also separate them into columns. Excel can interpret both formats.

Kasper Langmann

Thats all there is to it. Now youre ready to create a pie chart!

Change Theme Of Pie Charts

Sometimes, we want to match the pie chart colors to our theme. Instead of changing the color for each slice, you can change the theme of your pie chart. For that, click on your pie chart in Google Docs. Then hit the Format option at the top and select Image > Image options.

From the Image Options window on the right side, select the color matching your theme from the drop-down box under Re-colour.

Tip:

Also Check: The Key Lime Pie Company

You May Like: Bean Pie My Brother

Changing The Style And Color

Excel already has some neat pre-made styles and color combinations that you can use to instantly format your Pie charts.

When you select the chart, it will show you the two contextual tabs Design and Format.

These tabs only appear when you select the chart

Within the Design tab, you can change the Pie chart style by clicking on any of the pre-made styles. As soon as you select the style that you want, it will be applied to the chart.

You can also hover your cursor over these styles and it will show you a live preview of how your Pie chart would look when that style is applied.

You can also change the color combination of the chart by clicking on the Change Colors option and then selecting the one you want. Again, as you hover the cursor over these color combinations, it will show a live preview of the chart.

Pro Tip

Adding the data labels to a Pie chart is super easy.

Right-click on any of the slices and then click on Add Data Labels.

As soon as you do this. data labels would be added to each slice of the Pie chart.

And once you have added the data labels, there is a lot of customization you can do with it.

Quick Data Label Formatting from the Design Tab

A quick level of customization of the data labels is available in the Design tab, which becomes available when you select the chart.

Here are the steps to format the data label from the Design tab:

Why Use A Pie Chart

If youre here, youre probably already convinced that a pie chart is the best way to present your data. If not, though, here are a few reasons you should consider it:

1. It can show a lot of information at once.

Many charts specialize in showing one thing, like the value of a category. Pie charts are great for showing both a value and a proportion for each category.

That makes for a more efficient chart.

2. It allows for immediate analysis.

The way in which data is presented by a pie chart makes it very easy to make comparisons quickly. That allows viewers to analyze the data in a snap.

And thats what youre using a chart for in the first place, isnt it?

3. It requires little additional explanation.

Some graphs and charts include complicated information and arent intuitively clear. A box plot, for example, might leave audiences scratching their heads.

But nearly everyone knows how to read a pie chart. That makes it easier for you to present and for them to interpret.

4. Variations give you more options.

There are many different kinds of pie charts, and they each have distinct visual advantages. Well only be going over the basic chart here, but keep this in mind.

If you want to present your pie chart in a different format, theres probably a way to do it!

Convinced? Lets dive into making pie charts!

Kasper Langmann

And if you want to show change over time, a line chart is probably your best bet.

You May Like: Campbells Soup Recipe Chicken Pot Pie

Creating A Pie Chart In Excel

To create a Pie chart in Excel, you need to have your data structured as shown below.

The description of the pie slices should be in the left column and the data for each slice should be in the right column.

Once you have the data in place, below are the steps to create a Pie chart in Excel:

The above steps would instantly add a Pie chart on your worksheet .

While you can figure out the approximate value of each slice in the chart by looking at its size, its always better to add the actual values to each slice of the chart.

These are called the Data Labels

To add the data labels on each slice, right-click on any of the slices and click on Add Data Labels.

This will instantly add the values to each slice.

You can also easily format these data labels to look better on the chart .