how to create pie chart in excel with data

This is in the visible property of the screen. ) /* All that collection is the data for the piechart */ This article explains some the new chart types in Excel 2019 and shows you how to create, format, and interpret them. If(Priority = 'High' Collect(OnHold_C 1)) /* Here, you ask the value of Priority on the line you are on : depending on that value, you just add '1' in the collection that correspond with your browse*/ĬlearCollect(PieData /* Here, you create a collection with 4 lines, getting and the number of rows in the collections that correspond (you've got 1 line at each occurence) */ Excel still makes those charts (very well), but there are also many other options for presenting data in fresh ways that will make your audience sit up and take notice. You set the OnVisible statement of your sheet to : Clear(High_C) Ĭlear(OnHold_C) /* Here, you empty all the collections you'll use after */įorAll(ExcelData /* Here, you just browse your file line by line */ You have your Excel file linked to the Powerapp ( ExcelData ).

How to create pie chart in excel with data