I have a custom list in SharePoint Online that is setup with the following fields:
- Department (choices list)
- PPE Type (choices list)
- Amount (number)
On the home page of the site that contains this list, I would like to create a Quick Chart showing the PPE Types selected and the amount of each.
I know one of the axes or label types needs to be a Numerical column (that's "Amount", in this case). However, I can only seem to use "Title" as the other axis or label, regardless of what type of chart I pick (see both options below):
The issue is that each item in my list has a blank Title field, because I set it to Hidden. I turned on Management of Content Types to hide the "Title" field because there's no value in having an additional arbitrary text field per entry for this list, which will see hundreds of entries per day by as many users.
I considered changing the Title column to represent my PPE Type column, but you can't change the column type for Title. I also considered using a lookup or calculated column, but neither of those worked for the Quick chart, either, despite setting the ultimate display type to 'single line of text' for them.
How can I choose a different column other than Title for my Quick chart's non-numerical axis/label?