Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Remove or Group Legends by category in chart

Hi, 

 

I was wondering if there is a way to remove the "obvious" legends, as you can see in the chart below there are a number of legends as follows : 

X - Adopted ,  X - To be Adopted

Y - Adopted ,  Y - To be Adopted

Z - Adopted ,  Z - To be Adopted

And so on...

 

I'm looking for JUST have one Adopted and one To be Adopted legend, I'm using powerpivot 2013   ðŸ™‚

 

Thanks for your help!

 

Chart cleaned upChart with obvious legends

 

 

Need Help

5 Replies

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    Select the Line and column chart,turn to "format" as shown below:

    Turn X-axis On, the X-axis title displays below the X-axis labels>Turn the X-axis title to On.

    Here you can enter the title you need:

    For the related reference,pls click here.

     

     
    Best Regards,
    Kelly