![]() UPLOAD EXAMPLE - TROUBLE SHOOTING - SHARE PERSONAL ONEDRIVE FILE (NOT BUSINESS ONEDRIVE) You will have to move (copy) the example file to your personal (non-work) onedrive (or gdrive) and share it with us from there. We do not have permission to access your sharepoint. unfortunately without true data, I've had to make things up in order to have something to play and test with.Ĭlick here for document link(the link is removed by Mia) I'd like to trend the Matters Most: Other column and pull out/count all the times specific certain words appear. I'm not sure if a pivot table will even help. But now I can't get the chart to recognize these different numbers. What am I doing wrong? The only way I could get it to work was to put the total number of "yes" at the top of columns F-I. I want to show the percentage of what matters most and the chart is either coming up blank or like what is shown. Anyway, I'd like to create a dashboard in Excel to provide a visual for the data from a MS Form survey. I'm also not sure if I have the permissions to do so. Eventually this data could be put into PowerBI but that's going to take me a little longer. I was able to figure out how to do a power query for my data tab.
0 Comments
Leave a Reply. |