Forum Discussion

User232431's avatar
User232431
Helper III
1 year ago
Solved

Dynamic Legend in combo chart

Hi , ho do we create dynamic legend in combo chart instead default.
i.e get legend text from other column instead of value columns

Instead of default legend can we replace text from other columns.
if i select "Billing" in slicer the legend will be "Billing_1 Billing_2" (both are arrived from columns BarName and LineName).

Same with Porfit in slicer.

Thanks in advance

  • Hi User232431 ,

     

    In this case, the label name actually indicate to the name of value columns instead of legend label. The legend is not applied to line chart.

     

    If the line chart is a must, I'll suggest to use dynamic text as a workaround. Details please refer to the demo file.

     

     

1 Reply

  • isjoycewang's avatar
    isjoycewang
    Solution Supplier

    Hi User232431 ,

     

    In this case, the label name actually indicate to the name of value columns instead of legend label. The legend is not applied to line chart.

     

    If the line chart is a must, I'll suggest to use dynamic text as a workaround. Details please refer to the demo file.