Meter Chart Examples

image_pdfimage_print

Example 1: Odometer Full

Chart type: Meter – Odometer Full 
Data area for the chart: B2:F6
Data grouped by: Rows
Series labels: Yes
Category labels: Auto
Blue range: Values for speedometer needles
Gray range: Color areas for speedometer

Result: Odometer chart with default colors of Palette Apex.

Notes:
The greatest value in the chart area (in the example the value of F5: 250) defines the end value of the speedometer.
Later colors overlap earlier colors (in example: Light Blue covers Olive Green up 60 to 80).

Example 2: Odometer Half

Chart type: Meter – Odometer Half  
Data area for the chart: B2:D5
Data grouped by: Rows
Series labels: Yes
Category labels: Auto
Blue cell D2: Value for speedometer needle
Gray range:  Color areas for speedometer

Result: Speedometer with traffic light colors (customized).

Example 3: Wide Angular Meter

Chart type: Meter – Wide Angular Meter 
Data area for the chart: B2:D5
Data grouped by: Rows
Series labels: Yes
Category labels: Auto
Blue cell D2: Value for speedometer needle.
Gray range:  Color areas for speedometer.

Result: Speedometer with traffic light colors (customized).

Example 4: Odometer Full with Dual Axes

Chart type: Meter – Odometer Full with Dual Axes  
Data area for the chart: B2:F6
Data grouped by: Rows
Series labels: Yes
Category labels: Auto
Blue range: Values for speedometer needles
Gray range: Color areas for speedometer

Result: Odometer chart with traffic light colors (customized).

 

 

image_pdfimage_print
Was this post helpful?
NoYes (+1 rating, 1 votes)
Loading...