cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
audrieg
Level 10

Bar Chart Legend is Weird

Can anyone tell me how to get the legend to have the series labels (what you see in the screen shot directly on the bottom of the bar)? (I plan to remove those slanted words after I get this right, as I don't want people to have to tilt their heads.) I tried changing the Quanity to Item in the bar properties - but that swishes everything into 1 bar.

 

(Note: Value is the only possibility under serieslabels in the legend properties).

 

This has given me a headache, so any help at all will be appreciated! P.S. Is there a way to swap between bar and column charts (horizontal/vertical axis)

 

Thank you,

Audrie

 

BarChartProblem.PNG

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Steelman70
Level 10

Re: Bar Chart Legend is Weird

Here you go, is this what you were looking for?  Remember: you have to select an element of the chart before the legend will display.

 

CaptureAfterSelect.PNG

12 REPLIES 12
audrieg
Level 10

Re: Bar Chart Legend is Weird

Can anyone help with this?

Steelman70
Level 10

Re: Bar Chart Legend is Weird

Hi Audrie

 

1) The only way I could make it work was to do this:

 

Legend1.Items = ColumnChart1.SelectedItems

The result is below, but you have to click on the chart (i.e. select something) for it to show.

 

2) To remove the slanted words, you set:

 

ColumnChart1.GridStyle = GridStyle.None

 

3) I have found no way to create a horizontal chart

 

CaptureChart.PNG

audrieg
Level 10

Re: Bar Chart Legend is Weird

It won't work for me. Would you try to use the data in my screen shot and see if it works for you please? No matter what I do the legend is incorrect.

 

Thanks so much for your expertise in this area.

 

Audrie

Steelman70
Level 10

Re: Bar Chart Legend is Weird

Here you go, is this what you were looking for?  Remember: you have to select an element of the chart before the legend will display.

 

CaptureAfterSelect.PNG

audrieg
Level 10

Re: Bar Chart Legend is Weird

Would you mind sharing your app with me using OneDrive for Business? I just don't see how you did that using the table data provided. (sorry to be so needy).

 

thank you so very much!

Steelman70
Level 10

Re: Bar Chart Legend is Weird

ACTUALLY, STOP THIS IS EVEN BETTER

 

You just repeat the table, so you don't even have to select anything, simple!

 

Capture999.PNG

Steelman70
Level 10

Re: Bar Chart Legend is Weird

Here are the steps, it takes 3 minutes.

 

1) Create a new blank app

2) Create a new Column chart

3) Set the Items property of ColumnChart1 to this

Table(
{Item: "Section 8", Quantity: 1433},
{Item: "Pets", Quantity: 1200},
{Item: "Renewal", Quantity: 600},
{Item: "Moved", Quantity: 100}
)

4) Set the Items property of Legend1 to the same

 

That is all

audrieg
Level 10

Re: Bar Chart Legend is Weird

no reason to shout. if you look at my first screen shots - that is exactly what I did.

thanks for your help, i will figure out why mine didn't work. I accepted your solution anyway.

audrieg
Level 10

Re: Bar Chart Legend is Weird

My co-worker just said that you mean changing the legend to the same as the chart. That's quite unexpected because in your first chart - the one you made before I asked you to use my data - you had the following set:

 

notcrazy.PNGI'm not crazy

 

Then you changed the approach and said I need to put the same table list in the chart and in the legend. I can do that, but I think instead of shouting at me, you should have just explained why the approach would need to be different from the OOB way this is done.

 

Thank you.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 113 members 4,299 guests
Please welcome our newest community members: