I have created a stacked bar chart that is labeled with two pieces of data: total number of trips & the percentage difference between the YTD trip totals for this year and last year. By default, the labels for both measurements are located in two separate areas of each bar. My goal is to find a way to move both labels closer together and closer to the top of the bar. I would also like to add a carriage return to each label to separate the numbers and the text. For example, I would like to see something like the following near the top of each bar:
While I realize my goal could be accomplished by turning off "stack marks" in the Analysis drop-down menu and manually moving apart the resulting overlapping labels, I am looking for a dynamic solution that will automatically adjust the labels location whenever the height of each bar changes.
I would also like to know if it is possible to automatically align the grouped labels across of the bars in the chart to look something like this:
I have attached a packaged workbook of my efforts if anyone wants to give this challenge a try.
Thanks --- William
Currently, there is no way to automatically adjust the label locations. The best way is to manually move them to the desired location--I can totally relate with the frustration here! I would recommend add this to the Ideas section.