User Profile
Kevin_Burchell
Copper Contributor
Joined Nov 16, 2021
User Widgets
Recent Discussions
Downloading to Excel
Hi everyone, in my Form survey, I have some questions that have multiple answers and more than one can be selected (standard stuff). When I download my data to Excel, the multiple answers to each question all get dumped in the same column, which makes it very hard to count and analyse them. Does anyone know how to get the different answers to automatically show in different columns in the excel download? Thank you.Re: Bar charts switch order
Hi Riny Thank you. Forgive me, I am confused. You say format the categories in reverse but you have formatted them (in the spreadsheet) in the right order. Also, I cannot get the chart properties to show. In one of my charts, I have now used 'categories in reverse order' in Chart elements-Format axes to get the categories to reverse. However, I cannot see how to reverse the values. Anyway, thanks for your help, all the best KevinBar charts switch order
Hi everyone I wonder if someone can help with this challenge that has bugged me for a long time. I make a lot of bar charts in Excel. However, when I set up the data in a spreadsheet, the order of the categories is always reversed in the bar chart. You can see this in the screenshot. Can anyone tell me how to avoid this? Thank you! Kevin
