Sometimes your axis is busy with dual charts. So you don't have the luxury of using dual axis to create an end-of-line trend indicator. Here we are going to show that you don't need dual axis to do that.
The trick is easy: put it inside the Label.
This is how the last variance is calculated:
Put it in the Label:
Here are a couple variants of implementation:
- Custom Number formatting ;●;
Select red color for the font in the Label. If you want to use arrow to be the indicator, try this.
- Calculated field
The above is equivalent to a calculated field as follows [Last Delta Indicator]
- If [Last Delta]<0 then "●" end
Issue of alignment
There is a little issue of alignment if you want it to be perfectly on the data mark. We found a few ways to approximate the perfect alignment:
- Select middle and center alignment for the label.
- Use vertical font directions
- Adjust the axis scale so that the end point is not at the lower edge of the axis.
Here is a link to an example workbook. Try it.
That's it. Hope it works for you.
View comments