You can add a pie chart from the insert tab, and change the data source in the Items property by typing in Table1. Hello! It sounds like you have a good start getting data loaded. Slowly gaining confidence and getting results that are working. Kris, thank you very much again for the help and really clear examples with my data columns.
#Create pie chart in excel with no numbers code#
I needed to change that code to include Filter('Trial Progress List', 'Trial Manager'.Value="DeWayne Harper"), so just know you'll need to use the filter in both parts of the code in order to get the proper percentage values.
#Create pie chart in excel with no numbers trial#
Then, I was able to take it a step further and add a label control to show the percentage by adapting the code like the other example you linked earlier from my other post:įor anyone else attempting this, I was able to take the first image's code and basically copy and paste it into the label control inside the Text and Lookup functions, BUT the important difference was that CountRows('Trial Progress List') would return the percentage of true/false based on all rows, not just those where Trial Manager = DeWayne Harper. Your code guided me to the right solution, though I made a couple of tiny tweaks: Yes, the Trial Manager column is a choice column, which worked great with your code example. I figured this was a different enough request to warrant a different thread, since it displays the Yes/No ratio while filtering a separate column. (It's a small list, well under 500 records.)Īny ideas where I might be going wrong? Thanks much! When I take out the filter function and replace with only my data source, the pie chart displays all records with counts of yes/no. I also have a table with ONLY the filter function to make sure the filter works properly, and it does.
'Trial Progress List' is my data source, 'Trial Manager' is the column I want to filter by (show only records that are managed by "DeWayne Harper"), "Original_x0020_Data_x0020_Receiv" is the column I want to show the count of Yes/No.ĪddColumns(GroupBy(Filter('Trial Progress List', 'Trial Manager'.Value="DeWayne Harper"), "Original_x0020_Data_x0020_Receiv", "DataCount"), "Count", CountRows("DataCount")) I have gotten a pie chart to display yes/no count from all records, but I want one that displays a filtered table. I would like to display a pie chart showing the count of yes/no answers from a column from a SharePoint list.
0 kommentar(er)
