Back to all posts
FP&A
November 29, 2023

Choosing the scale for a graph

The scale for a graph axis can have significant impact on how an audience interprets a message and is an important part of optimising data visualization.

The scale selected for a graph axis has a significant impact on how the audience interprets the message and is an important part of optimising data visualisation. Here we cover the common issues financial planning & analysis professionals face when selecting chart axes and outline best practice guidelines.

Common constraints faced when choosing graph scales
  • The range of the tick marks on each scale to include the range of all the data to be plotted
  • The desire for the scales to be the same on all graphs within a composite panel for ease of audience interpretation
  • The need for a particular value (such as zero) to be included in a scale
  • The need for the chart to appropriately show the key trends in the data (often skewed by anomalies)
  • The desire for data points not to appear on the axes
Best practice visualization concept 1 – consider how the graph encodes the data

Different chart types encode data in different ways, understanding how your graph encodes the data is key to selecting the appropriate axis scale. Line graphs and dot charts emphasize the differences between values. However, in bar charts it is the length of the bar representing the absolute value of the data point that is the primary visual display and therefore of most importance. Different graph types subsequently have different principles for selecting scales.For more on selecting the right graph type see Chart Chooser for trends

Best practice visualization concept 2 – always include zero if possible

For bar charts, the axis should always start at zero since it is the length of the bar that is being used to encode the data.In Figure 1.0 the zigzags at the base of the bars are intended to warn the reader that the scale does not include zero. However, the bar lengths are meaningless in this rendition of the graph since they encode the data minus the arbitrary value 34.

best practise visualistation - here the graph scale does not include zero

Figure 1.0 - scale does not start at zero[/caption]If a bar chart is preferred, it should always include zero as Figure 2.0 shows:

best practise visualistation - graph scale includes zero

Figure 2.0 - bar graph scale should always start at zero[/caption]For line and dot charts, where appropriate, zero should also be included on the scale. This is to provide consistency with any other graph types featured on the same panel. It also ensures that trends in the data are not exacerbated misleadingly due to magnified scales. However, please see best practice concept 3 for important exceptions.

Best practice visualization concept 3 – use as much of the data region as possible

For line charts, within the constraints above, aim to “use as much of the data region as possible*”. What does this mean? In Figure 3.0 below the space from 0-30% is not utilized, only 15% of the vertical scale is taken up by the data. This wastes space and compromises resolution.

best practise visualistation - Here graph does not maximise data region

Figure 3.0 - graph does not maximize data region[/caption]In Figure 4.0 the scale has been adjusted to use more of the vertical space, whilst ensuring that the range of tick marks on the vertical scale includes all of the data that has been plotted. This also brings out the trend better, the fluctuation and decline in the metric is easier to interpret than in Figure 3.0.

best practise visualistation - scale adjusted to use more of the vertical space

Figure 4.0 - scale adjusted to use more of the vertical space[/caption]*William S Cleveland, The Elements of Graphich Data, 1985

Metapraxis has been at the forefront of data visualization for over 30 years and our research and best practice are integrated into our leading financial analytics platform, Metapraxis Empower.

Related Topics:

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
Choosing the scale for a graph
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