Value Chart Editors

Value layers can be viewed and edited either as tables or charts. As a chart, the values can be displayed either as a bar chart or line chart. In the upper right corner is a 3-bar icon for popping up the value chart menu as shown below. In the lower right corner is a resize icon for changing the size of the chart.

 

Each bar in the above chart represents the value for a particular period. Values can be changed by clicking or dragging the mouse on the chart. The value chart popup menu provides the following features.

  • Retitle - provides a way to give a title to this value chart editor, which allows it to be added to a slide
  • By year - shows a bar per year, rather than per period.
  • By quarter - shows a bar per quarter (only if a monthly model).
  • By period - shows a bar per period
  • Scaling - choice of auto scaling or fixed scaling
    • Auto Scale - choose a percentage which scales the largest value as some percentage of the chart value height.
    • Fixed Scale - choose upper and lower limits, any value beyond these limits are only shown up to the upper (or lower) limit.
  • Change to line chart - changes the display from a bar chart to a line chart
  • Change to bar chart - changes the display from a line chart to a bar chart
  • Round to nearest - choose rounding, typically set to 1 which will round new values, but leave existing ones as is
  • Curve Maker - allows specifying a variety of curves specified by the following parameters
    • Type of Curve:
      • Linear (default)
      • Growth Rate (specify growth rate)
      • Exponential (specify end value, otherwise same as growth rate)
      • Asymptotic
      • S Curve
    • Start of curve - specify start period at which curve is created
    • End of curve - specify end period at which the curve ends
    • Growth Rate - specify growth rate (per period or annual)
    • Start value of curve - specify value for the start period
    • End value of curve - specify value for the end period
    • S Curve Inflection Point - specify period for the inflection point of an s curve
    • S Curve Steepness - specify how steep the s curve should be (higher number is steeper)
  • Restore default values - restores previously saved default values
  • Reset to zeros - clears data back to all zeros
  • Restore previous values - undoes last change
  • Save as default values - saves current values as default values (which can be restored in the future)

 

Value Layers

Slide Decks