Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Line Chart Legend with two value and one series group

Answered Line Chart Legend with two value and one series group

  • Tuesday, February 28, 2012 5:09 PM
     
     
    Sign In to Vote
    0

    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

     

All Replies

  • Thursday, March 01, 2012 10:09 AM
    Moderator
     
     
    Sign In to Vote
    0

    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:12 AM
     
     
    Sign In to Vote
    0
    Discards your legend and add two series: Group1, Group2

    Regards, Nighting Liu

     
  • Thursday, March 01, 2012 10:19 AM
     
     Answered
    Sign In to Vote
    0

    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
    •