In the UX there is no good option for my client to display a chart with units in billions. The options are as follows:
- 分our final output line item by 10^9. They don’t want to display it as 3dp which is the required level of detail in other columns.
- 分our final output line item by 10^3 or 10^6. The interpretation is a confusing way to show a value in billions when referring to the axis, as shown in the image below.
- Leaving units as they are looks messy when they want to show data labels. The value for billions on the axis also shows as a ‘G’ which multiple clients have asked why this isn’t just designated by a 'B'.
Because of the use of data labels, a fairly good option would be the ability to change the font colour of each axis individually, so that I can at least hide the y-axis without losing the column chart labels on the x-axis.
The ideal scenario would be to select the units each line item should be displayed in within the module / on charts.
Thanks,
Ben