0

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):

Column chart showing "title" only Pie chart showing "title" only

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?

0

The reason you only see Title in the second axis list and not PPE Type is because it is the only field on your list that is a "single line of text" data type; Microsoft has not added support yet for different column types beyond "single line of text" and "number".

In fact, as of this writing not everyone has even received the feature rollout to connect a Quick Chart to a SharePoint list (though that rollout should complete soon).

There is currently a UserVoice suggestion for supporting Choice fields that you can vote up or comment on in the hopes of getting Microsoft to add support for this.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.