🎓
Models University
  • Alpha Testing
    • 👋Welcome to Alpha
    • Installation and Setup
    • Support and Help
    • Terms and Licence
  • Start Here
    • What is Models?
    • Quick start
    • Tutorials
  • Using Taglo Software
    • The Taglo Interface
      • Navigating in Models
      • List Views
      • Adding Items
      • Deleting Items
      • Searching and Filtering
      • Previewing and Editing
      • Using Wizards
      • Save/Undo/Redo
      • Keyboard Shortcuts
    • Data Storage
    • Namespaces
    • Inbuilt data
  • Tags
    • Introduction to Tags
    • Tag Basics
    • Tags Applet
    • Advanced Tags
  • Models
    • Home Tab
      • Creating a Model
        • Timings
      • Version History
      • Application Settings
    • Model Editor
  • Variables
    • Variable Basics
      • Variable Setup
      • Unit and Calculations
    • Time Segments
      • Time Segment Setup
    • Summaries
    • Default Assumptions
  • Units
    • Introduction to Units
    • Key Unit Concepts
    • Advanced Units
    • Defining a Unit
    • Unit Factors
  • Dimensions
    • Introduction to Dimensions
    • Dimension Setup
    • Defining Unit Variance by Dimension
  • Data Types
    • Data Types
  • Assumptions
    • Introduction to Assumptions
    • Creating/Referencing Assumptions
    • Assumptions Wizard
      • Assumption Dates Step
      • Assumption Values Step
      • Linking to external Data
      • Linking to Excel Inserts
      • Sensitivity Values
  • Calculations
    • Introduction to Calculations
    • The Calculation Page
      • The Formula Entry Bar
      • Unit Analysis
    • Calculation Parts
      • Variable References
        • Referencing Time
        • Referencing Dimensions
        • Lookups
        • Summarising Variables
      • Period References
      • Functions
        • Advanced Functions
  • Aggregation
    • Introduction to Aggregation
    • Creating Aggregations
  • Rearranging
    • Introduction to Rearranging
    • Rearranging Example
    • Rearranging Tips
  • Cases
    • Introduction to Cases
    • Managing Scenarios
    • Managing Sensitivities
  • Layout
    • Generating Excel
    • Auto Layout
    • Sheets
      • Sheet Content
      • Adding and Editing Content
    • Excel Formatting
      • Excel Themes and Styles
      • Line Formatting
    • Data Tables
    • Excel Generation Troubleshooting
  • Excel Inserts and Outputs
    • Excel Inserts
    • Excel Outputs
  • Number Formats
    • Number Formats
  • Dashboards
    • Dashboards Basics
    • Dashboard Layout
    • Dashboard Items
    • Excel Dashboards
  • Metrics
    • Metrics
  • Charts
    • Introduction to Charts
    • Chart Customisation
  • Importing Models
    • Importing Models
  • Data
    • Introduction to Data
    • Creating Data
    • Data Sources
Powered by GitBook
On this page
  • Chart Settings
  • Chart type
  • Labels
  • Time
  • Fix Series Axis
  • Data Shown (Categories, Series and Filters)
  1. Charts

Chart Customisation

How to alter the appearance of Charts

PreviousIntroduction to ChartsNextImporting Models

Last updated 3 months ago

Chart Settings

Each chart has an expandable Chart settings area in which four types of changes can be made:

  1. Chart type

  2. Labels

  3. Time

  4. Fix Series Axis

  5. Data shown

Below, we go through each of these in turn

Chart type

Chart type can be changed by simply selecting a new option from the Chart Type dropdown, as shown above.

Labels

Labels can be added to Charts using the Labels dropdown, as shown above. Available Label options depends on the Chart type.

Time

You can aggregate your charts over different time periods using the Time dropdown, as shown above.

Fix Series Axis

If "Fix Series Axis" is selected, the dimensions of the series axis (usually y-axis) will be set such that all scenarios/sensitivities can be shown on the chart without changing the axis. This gives a more visual experience when switching between scenarios.

If you want to look at an individual scenario in more detail, unselect "Fix Series Axis" and the series axis will then adjust to the best scale for just the selected scenario.

Data Shown (Categories, Series and Filters)

In the example below, the Variable has two Dimensions: Region (North, South), and Membership tier (Basic, Premium, Platinum). There are also two Scenarios and three Sensitivities in the Model. Here, Time has been chosen as the Chart's categories, and Region as the series (Chart axes). This means that only one combination of Membership tier, Sensitivities and Scenarios can be shown at a time (Chart filters). These are set to Basic, Base, and Base respectively (Filter values), but can be changed by the filter value dropdowns.

In the below example, we want to see information about the same Variable, but across both of its Dimensions, Region and Membership tier. This means we cannot keep Time as a dimension of the Chart; instead we use Region for categories, and Membership tier for series. This automatically makes Time a filter for our Chart, and we need to choose a specific date to show data for: in this case, we choose the last date of the Model, March 2028. Now we can see the difference between revenues across both region and membership tier simultaneously, at a given point in time.

A Models Chart can only show two dimensions at any given time. Usually one of the dimensions shown is Time, typically on the X-axis, meaning that the "series" of the Chart can only vary by one other dimension. This might be a of the Variable (or Assumptions), but it could also be the or of the Model. Any dimensions that are not chosen as Chart categories or series, must be specified as a filter.

Dimension
Scenarios
Sensitivities
The Chart settings area
Example Chart types
Example Label positioning
Charts aggregated over different Time Periods
Chart controls for choosing which data to display
Example of non-time-based Chart
Screenshot of a chart, showing the expanded chart settings area which contains various controls