Forum Discussion
Y Axis position and data labels
Hi All,
I would like to know if it is possible to position a datalabel between the last data point and the Y Axis.
Example with datalabels on the left:
Same example with datalabels on the right:
As you can see the datalabels override the Y Axis label.
I would like to move the Y axis at a custom position. More to the right in order to have the datalabel after the last datapoint but before the Y Axis and thus no override.
But it does not seem possible.
I tried to play with the margin of the Y axis to cheat a little but it is disable.
Any idea how to do it ?
Thanks,
Concaho
Some libraries have built-in features for handling data label overlaps by using data label collision detection or automatic positioning. Check if your library supports this feature and if it can help reposition the data labels accordingly.
Add another column to your data that has your desired label value (e.g., the value you want displayed) for the last data point and a blank cell for all others. Create a new series in your chart using this dummy data. This series will create an additional point you can manipulate.
Hi Cole,
I am not sure adding a new series with only one point (at the end) solves my problem.
I can create a new datalabel for this new serie and this endpoint but I still have my problem. Too close of the Y axis.
I also tried to select more cells from my vector of date. (emtpy cells) but it didn't change anything.
Thanks,
