You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »

Spreadsheet Format

Each row represents a pie slice. 

 Column 1Column 2
Data Typeplain textnumber
Contents

The label for the pie slice

Note:

  • This label will appear when the viewer hovers their cursor over a slice

The numerical value of the pie slice

Note:

  • Visualizations uses this column to calculate the percentage for each slice

 

Customization Options

Go to Common Options for Charts and Graphs for more options.

3D Chart?: choose whether you want your pie chart to look 2D or 3D

  • "False"= 2D
  • "True"= 3D

Pie hole size: choose whether you want your pie chart to look like a circle or a bagel

  • type a number between 0 and 1 into the textbox
  • note that numbers closer to 1 will create a larger hole; if you do not want a hole, type in 0

Minimum visible slice: set the size of the smallest piece of pie

  • the default setting is 0.001
  • type in a number between 0 and 1
  • for example, if you type in .5, slices less than 50% of the pie will not appear

Pie slice text information: choose the label you want to display on your pie slices

  • "Percentage": the pie slice will show its percentage of the whole
  • "Label: the pie slice will show the label you assigned it in the spreadsheet
  • "Value": the pie slice will show the number you assigned it in the spreadsheet
  • "None": the pie slice will have no text upon it

Pie slice text settings: choose how you want your font to appear in the pie chart

  • click inside the textbox to show a dialogue box
  • choose a font; it's better to use a standard font, such as Ariel or Times New Roman, to ensure that it will appear the same way across different devices
  • choose a font size; enter a size as small as 1; the default size is 12
  • choose a font color
    • click the color square to show the ColorPicker tool
    • choose a color
  • No labels