none
Line Chart Legend with two value and one series group

    Question

  • Hi,

    I am creating a Line Chart that contains two values (ValueA, ValueB) in the Chart Data Value and Year1 in Category Groups and Group1 in Series Group.This outputs a Legend as follows for me:

    Group1 - ValueA

    Group1 - ValueB

    Group2 - ValueA

    Group2 - ValueB

    How can I change it so that it displays

    Group1

    Group2

    ...

    ...

    Thanks,

    Sam

    Tuesday, February 28, 2012 5:09 PM

Answers

  • Thanks Bill Liu,

    I found the answer by playing around with it.

    -> Right click on the Chart Series and click 'Series Properties'

    -> Click Legend on the left pane

    -> Type in the text you want in the 'Custom Legend Text' textbox

    -> Repeat the steps above for more series

    • Marked as answer by samuelmoneill Thursday, March 01, 2012 10:19 AM
    Thursday, March 01, 2012 10:19 AM

All replies

  • Hi samuelmoneil,

    Thanks for your post.

    But I don’t think the description is correct. Based on my experience, when you view your report the legend would show according to the actual series values(if you specify series group). I mean if you specify group filed as the only series group column, the the legend would show according to the actual group fields values, if you have two group(group1, group2), when you run your report , it would show only these two legend(group1,group2), if you specify both Group and Value fields as series columns in sequence, the result would like you descript format:
    Group1 – ValueA
    Group1 – ValueB
    Group2 – ValueA
    Group2 - ValueB

    Thanks,
    Bill Lu


    Bill Lu

    TechNet Community Support

    Thursday, March 01, 2012 10:09 AM
  • Discards your legend and add two series: Group1, Group2

    Regards, Nighting Liu

    Thursday, March 01, 2012 10:12 AM
  • Thanks Bill Liu,

    I found the answer by playing around with it.

    -> Right click on the Chart Series and click 'Series Properties'

    -> Click Legend on the left pane

    -> Type in the text you want in the 'Custom Legend Text' textbox

    -> Repeat the steps above for more series

    • Marked as answer by samuelmoneill Thursday, March 01, 2012 10:19 AM
    Thursday, March 01, 2012 10:19 AM