Charts: Long Data Series Labels
Grouped items, when used as Axis or Legend labels in charts, now appear with their full names, including any groupings.
For example, when displaying a chart where the X-Axis Category consists of consecutive, non-repeating years grouped into “Historical”, “Current”, and “Projected”, every Item will appear with all its nested groupings.
I normally use Quantrix v3.1, and it only shows Item groupings to differentiate between otherwise identical Item names, but v4.0 will display an Item named “Projected.2010” in full, instead of just displaying “2010”, thus actually showing “Proje…” several times (a long series of fully-named Items won’t fit in the X-Axis).
Is there an option in v4.0 for showing Item names in the most economical way? (i.e., “2010” instead of “Projected.2010”)
Mario
P.S.:
Showing full nested groupings would be useful if these were broken into rows like in Excel Pivot Charts, where you would have the Years on the top row of the X-Axis labels, with any nested categories (such as “Actual” or “Budget”) appearing underneath in separate rows.
Hi – to avoid using the group name in a chart x-axis label:
– Edit the Chart section of the format toolbox, and click on the Point Label
– Enter an expression of @categoryName. Assuming your category is named Year, you would enter:
@Year
The @ symbol tells Quantrix to reach inside the category and use the base item name.
Another way to do it is to use the @level function. So:
@level(Year,2)
Would use the second “level” of names. Level 1 would be the group names, while level 2 would be the item names. If you have groups on top of groups you could use level 3, level 4 etc.