Question

What can you do if you want to have totals and other smaller numbers in the same chart but don't want the totals to dwarf the other values?

Option 1: Use a secondary axis for totals
Option 2: Increase the font size of smaller numbers
Option 3: Change the chart type to a stacked bar chart
Option 4: Hide the totals in a separate chart

Answer 1

To avoid the totals dominating smaller numbers in a chart, you can use a secondary axis, increase the font size of smaller numbers, or change the chart type to a stacked bar chart.

Step-by-step explanation:

If you want to have totals and other smaller numbers in the same chart but don't want the totals to dwarf the other values, there are a few options you can consider:

1. Option 1: Use a secondary axis for totals. This allows you to show the totals on a separate axis, making them visually distinct from the other values.
2. Option 2: Increase the font size of smaller numbers. By making the smaller numbers more prominent, they can stand out even when presented alongside the totals.
3. Option 3: Change the chart type to a stacked bar chart. This type of chart allows you to show both the totals and the smaller numbers in the same visual representation, without one dominating the other.