9.5 Chart Options (修訂 #56)

Chart Options

• Use 2D View: Display charts in 2D
  
• Lighting: Lighting technique(Default, Bright, Dark, Ambient)
  
• Chart Font: Display chart font
  
• Background Top Color: Background gradient top color
  
• Background Bottom Color: Background gradient bottom color
  
• Chart Title: Display the chart title
  
• Value Axis Title : Display the value axis title
  
• Category Axis Title: Display the category axis title
  
• Show Grid: Show / Hide chart grid
  
• Merge Series Axes: Merge all series axes into a single axis
  
• Scale Data Range to Zero: Scale the data range to zero
• Show Value Axis: Show / Hide value axis
  
• Value Axis Number Format: Specify the format for numbers displayed on the value axis
  
• Show Category Axis: Show / Hide category axis
  
• Category Axis Number Format: Specify the format for numbers displayed on the category axis
  
• Category Axis Date & Time Format: Specify the format for dates & time displayed on the category axis
  
• Numeric Category Axis: Plot data along the category axis using a numeric or datetime range
  
• Show Series Axis: Show / hide series axis
  
• Line Width: Width of lines in line chart
  
• Show Markers: Show markers at the location of the data point
  
• Display Stack as Percentage: Display stacked values as percentage of total
  
• Group Pie Small Values: Group small pie chart values into a single slice
  
• Group Pie Small Values Threshold: Group small pie chart values using the specified threshold
  
• Explode Pie Chart: Separates the pie chart by the specified amount of space
  
• Show Pie Lines: Show lines connecting the pie pieces and labels
  
• Pie Label Distance: Specify the distance between the pie chart pieces and their labels
  
• Show Fixed Category Count: Show the top <N> categories of data in the chart
  
• Fixed Category Count: Specify the number of categories to display in the chart
  
• Width: Maximum width of the chart
  
• Height: Maximum height of the chart
  
• Depth: Maximum depth of the chart
  
• Category Spacing: The category spacing
  
• Series Spacing: The series spacing
  
• Show Legend: Show / Hide legend in chart
  
• Legend Position: Position of legend on chart panel
  
• Legend Height Type: Specify if legend is stretched vertically, fits the items or uses the exact height
  
• Legend Height: Specify exact height of legend panel
  
• Legend Width Type: Specify if legend is stretched horizontally, fits the items, or uses the exact width
  
• Legend Width: Specify exact width of legend panel
  

Chart Function Series

In the Advanced tab, you have the ability to add and remove virtual function series.  A function series is a series of data that is based on a series of data with applied function to the series values.  The current functions that may be used are:

• Add
  First Parameter: Series Number (1 indicates first series, 2 indicates second, ...)
  Second Parameter: Series Number (1 indicates first series, 2 indicates second, ...)
  Result: For every row of data, add First Series value to Second Series value


• Subtract
  First Parameter: Series Number (1 indicates first series, 2 indicates second, ...)
  Second Parameter: Series Number (1 indicates first series, 2 indicates second, ...)
  Result: For every row of data, subtract Second Series value from First Series value


• Scalar
  First Parameter: Series Number (1 indicates first series, 2 indicates second, ...)
  Second Parameter: Scalar Value
  Result: For every row of data, multiply Series value by Scalar


• Power
  First Parameter: Series Number (1 indicates first series, 2 indicates second, ...)
  Second Parameter: Exponent
  Result: For every row of data, find Series value to the Exponent power


• Log
  First Parameter: Series Number (1 indicates first series, 2 indicates second, ...)
  Second Parameter: Logarithm Base
  Result: For every row of data, find the logarithm of Series value


• Moving Average
  First Parameter: Series Number (1 indicates first series, 2 indicates second, ...)
  Second Parameter: Count of data points to average
  Result: For every row of data, find the average of the Series values for this row and Count - 1 preceding rows


• Linear Regression
  First Parameter: Series Number (1 indicates first series, 2 indicates second, ...)
  Result: Perform a least-squares regression analysis on the Series values

For each of the series you may also enable the showing of the function meta data.  The Linear Regression function contains the Slope & Intercept as the meta data.