Forms, excel, and pivot table

%3CLINGO-SUB%20id%3D%22lingo-sub-2083718%22%20slang%3D%22en-US%22%3EForms%2C%20excel%2C%20and%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2083718%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20work%20in%20quality%20and%20our%20auditors%20use%20tablets%20to%20fill%20out%20MS%20Forms%20as%20the%20y%20do%20their%20daily%20rounds.%20This%20makes%20it%20really%20convenient%20to%20collect%20and%20share%20data%20through%20our%20SharePoint%20site.%3C%2FP%3E%3CP%3EI%20am%20having%20trouble%20as%20I%20try%20to%20create%20a%20pivot%20table%20and%20create%20a%20chart%20to%20present%20numerical%20values.%20When%20the%20data%20comes%20in%20from%20my%20forms%20it's%20not%20formatting%20as%20a%20number%20and%20therefor%20my%20pivot%20isn't%20pulling%20it%20to%20calculate.%20Any%20ideas%3F%20I%20have%20formatted%20the%20columns%20as%20numbers%20and%20restricted%20responses%20to%20numbers%20on%20the%20form.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2083718%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPivot%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello all, 

I work in quality and our auditors use tablets to fill out MS Forms as the y do their daily rounds. This makes it really convenient to collect and share data through our SharePoint site.

I am having trouble as I try to create a pivot table and create a chart to present numerical values. When the data comes in from my forms it's not formatting as a number and therefor my pivot isn't pulling it to calculate. Any ideas? I have formatted the columns as numbers and restricted responses to numbers on the form.

Thanks

0 Replies