Forum Discussion
How to change the Data Label Order in a Column Chart.
Is there a way to change the Data Label order in a column chart. In the chart below I would like to change the labels from (left to right) Adjusted EBITDA Mgmt, Revenue, Total Pounds to Total Pounds, Revenue, Adjusted EBITDA. Can this be done?
Hi Anonymous,
Based on your screenshot, you have a category field named Business Unit containing these values: Adjusted EBITDA Mgmt, Revenue, Total Pounds, and you drag the category field to Legend of column chart.
In this scenario, if you want to modify the Legend order, you would need to create separate measures to calculate the results for each type of Business Unit, then place each measure in the Values area in order you wish. For more details, please review this similar thread, it works for column chart.
Thanks,
Lydia Zhang
2 Replies
Hi Anonymous,
Based on your screenshot, you have a category field named Business Unit containing these values: Adjusted EBITDA Mgmt, Revenue, Total Pounds, and you drag the category field to Legend of column chart.
In this scenario, if you want to modify the Legend order, you would need to create separate measures to calculate the results for each type of Business Unit, then place each measure in the Values area in order you wish. For more details, please review this similar thread, it works for column chart.
Thanks,
Lydia Zhang