I creating a SharePoint site for my client and using SharePoint 365. I am trying to add web parts to show a chart of a list of data that is already in the sharepoint site. So when I choose the Business and Intelligence web Part, then Quick [Pie] chart. For data, I choose "Get data from a Sharepoint list on this site".
For column that has the data to display, I only get 2 options, how can I pull the other 5 columns to come up here
For Horizontal axis labels, I only get 2 options, how can I pull the other 5 options to show up.