Forum Discussion

Minyun's avatar
Minyun
Frequent Visitor
4 years ago

Clustered Line Combo Value Positions

Hi,

 

Pretty straight forward. Can anyone give me some advice on how to ensure that my line values always appear consecutively?

 

See below: The September 'Target' value of 1577 is below the 'Forecast' value of 1626 (as expected) however note how the October 'Target' value of 1638 is below the 'Forecast' value of 1608 (not as expected).

I have tried to play around with the Format/Data Labels/Customize Series/../Position/..[Under;Above;Auto] but I always end up with some month's value being nonconsecutive. Below is an example of setting both Line position's to Auto (now September is skewed):

Is there some other way to ensure line values are displayed consecutively?

Tips and Tricks

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    4 years ago

    Hi Minyun ,

     

    This is not an easy thing to align especially when the values are so close I have made a small sample and placing one value on top and the other below return the expected result so all labels were consecutive.

     

    But this is a very frustating issue some times.