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

Compare with Current View Page History

« Previous Version 11 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 Customize Your Chart for more options.

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

  • click an option from the drop-down menu
  • 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, prompting a dialogue box to appear
  • 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, prompting the ColorPicker tool to appear
    • choose a color
  • Click Ok
  • No labels