cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Building a Bar Chart from Sharepoint Data List

Hi there,

 

I have a SharePoint list of data which is set up in the following way.

 

Sharepoint Data Table.jpg

What I want to be able to do is chart a bar chart with the months of the year along the bottom Jan-Dec and then the value. TheChart would be able to be filtered by two drop-down menus - one for Event and the Other from Financial Year. 

 

I am trying the following but am struggling as to how to get the months of the year along to the bottom of the chart.

 

Filter('2020 - Historical Data - Master' , Event = Historic_Data_MONTH__2_DD.Selected.Value && 'Financial Year' = Historic_Data_MONTH_DD.Selected.Value)

 

The Dropdown that controls the Event has the following in.

 

["VALUATION", "TAKE ON", "SSTC", "EXCHANGE", "VIEWINGS"]

 

and the Dropdown that controls the year as the following in.

 

["VALUATION", "TAKE ON", "SSTC", "EXCHANGE", "VIEWINGS"]

 

Any help would be gratefully received. 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Hi @LaingBennett :

Do you want to show 12 series from Jan. to Dec. in a Column chart?

I'm afraid that is not available ,because one Column chart only support at most 9 series.My alternative is to combine two Column charts.I'v made a test for your reference:

Column chart1

2.JPG1.JPG

Column chart2

3.JPG4.JPG

The result

74.gif

Best Regards,

Bof

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Hi @LaingBennett :

Do you want to show 12 series from Jan. to Dec. in a Column chart?

I'm afraid that is not available ,because one Column chart only support at most 9 series.My alternative is to combine two Column charts.I'v made a test for your reference:

Column chart1

2.JPG1.JPG

Column chart2

3.JPG4.JPG

The result

74.gif

Best Regards,

Bof

View solution in original post

Highlighted

Hi there,

 

Thank you for this. 

 

I didn't realise there was a limit to the number of series in the Chart. 

 

Regards

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (9,862)