cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
audrieg
Power Automate
Power Automate

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

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

View solution in original post

12 REPLIES 12
audrieg
Power Automate
Power Automate

Can anyone help with this?

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

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

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

View solution in original post

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!

ACTUALLY, STOP THIS IS EVEN BETTER

 

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

 

Capture999.PNG

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
Power Automate
Power Automate

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.

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:

 

I'm not crazyI'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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Carousel April Dunnam Updated 768x460.jpg

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors
Users online (3,135)