For trend lines and reference lines, in addition to the toggle break down by legend, you also have another toggle, merge into one line, which helps visualize a single global line despite the legend.
Although both toggles produce the same result of one single line in the chart, their calculations differ:
- Turning off “break down by legend”: This calculates the trend line or reference line based on the total values (i.e., not segmented by legend).
- Turning on “merge into one line”: This calculates the trend line or reference line based on the segmented values.
For more detailed examples, please refer to these documents:
- Trend Lines: Display one or multiple trend lines
- Reference Lines: Display one or multiple reference lines