3 Replies Latest reply on Jan 27, 2016 10:01 PM by Rajeev Pandey

# Pie Graph

How do I create a pie graph to understand the % sales of the items sold in a day? Data is attached.

• ###### 1. Re: Pie Graph

Hi Margaret-

Here you go.

9.2.2 workbook attached.

1 of 1 people found this helpful
• ###### 2. Re: Pie Graph

Hi, Margaret

First of all, for detail and more accurate procedure, go to the link site.

Here is  a step anyways.

Put [Sales] in Label box

Change chart type to Pie

Put [Fruit] in Color

Put [Sales] in Angle

Put one more [Sales] in field, and Change it to Table Calc.

Make Size bigger.  with changing view to Entire.

Thanks,

Shin

1 of 1 people found this helpful
• ###### 3. Re: Pie Graph

Dear Margaret,

I cant download any file in my workstation so I am using a Sample Superstore data for explaining the below Viz creation.

Please find the detailed Steps through Which you can create either Pie chart or Donut Chart .

1) As per the below image , you can see  you need 1 or More Dimensions and 1 or Measures

2)  Then CTRL+CLICK the required Dimension and Measures from the data source.

4) Click on Mark levels present at the top of the toolbar.

5) Then Right Click on the Sales Mark which is representing the Angle , go to quick table Calculation and Select % total

6) It will Generate the % . You can also Drag these Percentage Inside the Pie Chart .

Note: if you are Having so many Pie angles , then use annotation for Representing the data

1) Drag a Year(order date) to the Row Shelf and make a Copy of the Year(order date)

2) Double Click on Sales measures and Convert the Year(order date) from Discrete to Continous , Something Like below

3) Right Click on Order date and Select Dual Axis . Also Change the Marks from Automatic to Circle.

4) Just for your better Understanding , We will be taking a Single Year . So apply a Filter on "year (order Date)"

5)Hide the header for yearly axis so that the veiw look flawless.

6) Right click on the view and select format . Go to "Lines" and make the "Zero" line as none

7) Now Change the marks card  from Circle to Pie.

8) Add region to the Color Marks card of Year(order date) (not the Year(order date)2) . We Will be using it as Circumference.

9)Go to the Copy of the Second  year(order date ) 2 and Select the Color marks Card and change the color to White ( this is the Inner Circle).

You can also add Black border for both the Color marks card i.e year(order date ) and year(order date ) 2

10) Once you completed the Steps , you final result will look like below Diagram.

if this solves your issue , kindly mark the answer as correct This will help other members when they are searching for solutions to similar problems.

1 of 1 people found this helpful