Multiple line chart and data labels

Hi in a multiple line chart is it possible to have one line with data labels and the other without any data labels?

Best Answer

  • Sean_Tully
    Sean_Tully Contributor
    Answer ✓

    I think you can do this by creating a beast mode that outputs only for the line you want, and outputs a blank string ('') for all the other lines in the series. You can drop the beast mode into the tooltip slot, and then choose the tooltip as your label in data label settings. This worked for me when I tested it on a chart with two lines.

Answers

  • Sean_Tully
    Sean_Tully Contributor
    Answer ✓

    I think you can do this by creating a beast mode that outputs only for the line you want, and outputs a blank string ('') for all the other lines in the series. You can drop the beast mode into the tooltip slot, and then choose the tooltip as your label in data label settings. This worked for me when I tested it on a chart with two lines.

  • Thanks. What beast mode formula did you use?

  • Hi Sean, can you share the beast mode formula you used.

  • Sean_Tully
    Sean_Tully Contributor

    Sorry, I didn't save it, but it would be something like:

    case when category = 'A' then category else '' end

    The basic idea is to return the label for the series you want, and then a blank string ('') for the others.