I have searched high and low and cannot figure out how to create a pie chart using an excel table. I just want the chart to display data within the table. I have attached screenshot of table below. Please assist. Thanks.
Do note that linking PowerApps (and I'm assuming you're asking about a Pie chart in PowerApps and not in Excel), to an Excel table doesn't really happen. The data is IMPORTED from Excel at design time. It is not renewed at run-time. So when a user logs in, they see the Pie Chart that is based on data that existed when you imported it from Excel originally (or when you last refreshed it).
Pie Charts take a Collection (table of data) as an input. So importing an Excel data table would work fine. Just set the Items property for your Pie Chart to be the name of the table you imported from Excel. (E.g. Table1)
You can break this down into steps. First verify that you can show a Collection that you created manually.
At this point your chart should display the data properly. If this works, then you need to take a look at how you're importing the information from Excel.
Actually, if/when you import an Excel table, you created a Collection (like magic!) in your PowerApp. Just think of Collections as Excel tables and that'll keep things straight.
So if the example I did above works for you (and the Pie Chart displayed my birds/bees data properly) and when you then pointed your Pie Chart at the Excel table it doesn't show any data, then your Excel table is empty (probably). Again, the Excel table was imported when you created it IN POWERAPPS. If you went into Excel, created the table (but didn't put any data in) and then imported it into PowerApps and THEN put data into your Excel table, it would not show the new data.
Keep your eyes open for our upcoming T-shirt design contest!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020