Spreadsheet Format

Each row represents an individual gauge. Five rows will make five gauges on the display

Customization Options

Go to Customize Your Chart for more options

Height of gauges: controls how tall you want your gauges to appear

• enter a number anywhere between 5 and 9000

Width of gauges: controls how wide you want your gauges to appear

• enter a number anywhere between 5 and 9000

Green zone color: creates a third zone in your gauge

• the default color is set to green
• click the color box to show a color wheel
  • choose the color for your third zone
  • click Ok

Green zone start

• type in the number where you want the green zone to begin on the gauge

Green zone end

• type a number into the textbox where you want the green zone to end on the gauge

Maximum gauge range: sets the highest value the gauge reads

• type a number into the textbox
• numbers can be expressed as: negative and positive numbers, decimals, and fractions

Minimum gauge range: sets the lowest value the gauge reads

• type in a number into the textbox
• numbers can be expressed as: negative and positive numbers, decimals, and fractions

Major tick labels: sets how many big tick marks you want to display on your gauge

• the default number is set to 5, with only the maximum and minimum gauge labels appearing on the gauge
• to label major ticks, enter comma separated values in the order in which you want them to appear on the gauge

Number of minor tick marks: sets how many small tick marks you want to display on your gauge

• Type in the number of minor tick marks you want to appear between each major tick mark

Red zone color: sets the color of the first zone in your gauge

• the default color is set to red
• click the color box to show a color wheel
  • choose the color for your first zone
  • click Ok

Red zone start

• type in the number where you want the red zone to begin on the gauge

Red zone end

• type in the number where you want the red zone to end on the gauge

Yellow zone color: sets the color of the second zone in your gauge

• the default color is set to yellow
• click the color box to show a color wheel
  • choose a color for your second zone
  • click Ok

Yellow zone start

• type in the number where you want the yellow zone to begin on the gauge

Yellow zone end

• type in the number where you want the yellow zone to end on the gauge