Back to all posts
FP&A
November 29, 2023

A chart chooser for trends

Developing a chart chooser for each of the seven trend categories

In this earlier post, we introduced a high level Analysis Library for business that classifies charts frequently used to visualize management information into seven high level groupings.  Having now defined and explained the fundamental dimensions of MI, we can develop a chart chooser for each of the seven categories.Our first grouping focuses on the fundamental business requirements to analyse trends over time.  Our trend chart chooser looks like this.

Trend chart chooser

The first thing we need to decide is what kind of comparison is called for by the business question the chart must answer.  Here are some examples:

1. What is the trend of total working capital compared to budget?

Answering this question requires a trend chart that compares modes (in this case actual and forecast compared to budget).

2. How have the proportions of consumer spending by category evolved over the last 10 years?

This question implies a trend chart that analyses the composition of items.

3. How do gross margin trends compare across our regions?

This question calls for a trend chart that compares units.

4. What is the trend in our profit and cash generation, and the profit into cash ratio?

Answering this question means comparing the relationship between items.

Having narrowed down our focus to a particular branch of the chart chooser, we can then home in on the best type of chart to answer the specific business question.  For example:

Question 1 is probably best answered by a Trend line chart because working capital is a ‘stock’ type of item.

Question 2 is a ‘part to whole’ question that is best addressed by a 100% area or possibly a 100% bar chart.

Question 3 requires us to trend a statistic for a group of units and hence is best answered by a Multiple line chart.

Question 4 implies comparing the relationship between two flow type items and a statistic, for which a multiple unit/item chart would probably work best.

What’s a Rich Text element?

The rich text element allows you to create and format headings, paragraphs, blockquotes, images, and video all in one place instead of having to add and format them individually. Just double-click and easily create content.

Static and dynamic content editing

A rich text element can be used with static or dynamic content. For static content, just drop it into any page and begin editing. For dynamic content, add a rich text field to any collection and then connect a rich text element to that field in the settings panel. Voila!

How to customize formatting for each rich text

Headings, paragraphs, blockquotes, figures, images, and figure captions can all be styled after a class is added to the rich text element using the "When inside of" nested selector system.

  • ffff
  • ffff
Abhishek Singh
Customer Delivery US
Abhi joined us in 2011 and heads up our Client Delivery Team from our US office. A devoted fan of the Indian cricket team and, when not watching cricket, plays cricket at a high level himself.
Popular POst
FP&A
A chart chooser for trends
Follow us

Latest Posts

Navigating Challenges in Construction
eBooks
Navigating Challenges in Construction
Explore how the construction industry confronts economic volatility, technological integration, and strategic decisions. Uncover the effects of economic downturns and policy shifts, delve into the significance of digital transformation, and grasp strategies for bolstering resilience through innovation.
Read more
Navigating a 2024 Tech Investment Slowdown
FP&A
Navigating a 2024 Tech Investment Slowdown
Managing Internal Tech Investment Slowdowns in 2024 with savvy finance strategies: streamline operations, rethink ROI, and set dynamic objectives for a resilient financial approach.
Read more
What does 2024 look like for FP&A teams?
FP&A
What does 2024 look like for FP&A teams?
2024 poses unique challenges for FP&A teams amidst a shifting financial landscape. Here we delve into the anticipated obstacles, developmental prospects, and socio-economic trends that will shape the course of businesses in the upcoming year.
Read more