You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Prevent hierarchy axis label concatenation

This is such an exotic change that it needs the scene setting! Imagine
that you have a shopping database, and include in a single table the region,
town and shopping centre in which transactions take place. You can then
create a hierarchy based on these 3 columns:

You can right-click in the field well to create a hierarchy, then drag fields into it (not shown here).

You could now use this to create a chart:

The chart uses the hierarchy for its axis.

You could then drill-down to show all of the levels of the hierarchy on a single
chart:

Click on the symbol shown to expand the hierarchy.

Here's what you get by default:

The labels are impossible to read, consisting as they do of the region, town and centre name concatenated together.