When we want to show the impact of a proposed change, one of the ways we can do it is to show a line graph of the current state and the proposed state with a shaded area between the two to emphasize the difference. This is much better than the default table of values that… Continue reading Showing future differences; Issue #433 February 19 2019
You’ve analyzed the past data and need to communicate important findings to the executives or Board. If you want to show how the trends in different measurements compare to each other even though they are measured in different units, this video shows how to use an index line graph to allow the viewers to quickly… Continue reading Presenting financial analysis: Show trends in data series measured in different units
Use an index line graph to compare trends in different data series using a common starting point
Use a line graph instead of a column graph to show both the trend and comparisons to previous values.
Use an index line graph instead of a dual axis chart to compare trends in different data series.
Use a line graph instead of a clustered column graph to show trends
A line graph is easier to see trends in multiple data series than a stacked column graph