Displaying a baseline or target line on a chart is a common requirement. The use case is simple – We have an SLA and want to depict real life against the target. I didn’t think this could be done until recently, let me show you how.
The solution is very simple, but not obvious. The trick involves two steps. Firstly, using Custom Summary Formulas (CSF) with a static value representing your baseline, ‘0.8’ in my example (see example, right). Secondly, with our ‘SLA Target’ CSF column we can use Combination Charts to display additional sets of data on your chart. In the chart editor when you select ‘Plot additional value’ you will be able to select your Baseline column. Thats it. Simple.