1

I'm creating a treegraph in Microsoft Excel, but my labels get truncated unnecessarily. See the image below:

The tree graph with wrongly truncated labels

As you can see, the second digit of the labels of the smallest rectangles, which are the numbers 12 to 16, have wrongly been replaced with three dots. The three dots are larger than the actual character they are replacing, making the sizing problem even worse.

Of course a simple solution is too simply resize the chart or lower the label font's size, but this isn't as aesthetically pleasant. The font simply gets unnecessarily tiny:

The treemap resized

The treemap with a reduced label font size

I have looked online and searched Microsoft's documentation, but I couldn't find any solution. Does anyone maybe have an idea how I could disables Microsoft auto truncation or does anyone have any other ideas how I could get a nice looking graph?

The data visualised is btw as follows:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
3306 825 370 250 146 141 88 62 48 34 43 19 18 18 18 13
Bassie-c
  • 128

1 Answers1

0

The only parameter that is available for modification here is the spacing between characters (kerning).
You can experiment with setting a reduction of about 0.5 points. The characters are not yet overlapping. Instead of ... the second digit can be displayed on the next line.
Tree view

MGonet
  • 4,015