I have a simple dataset that has a column called status, which is text. I’m trying to create a simple bar or pie chart that shows the status values and the count of rows with that status. A simple thing to do in say Excel, but I’ve been trying to create this visualization for over an hour and still can’t seem to get it to work. What am I missing?

When you define the chart, did you set the X Axis type to Category?

Oh, wait. In your dataset, do you have just a list of statuses? Or is it status, count kind of rows?

The dataset is a list of status (and other columns) without counts

ID Name Status
001 Albert Complete
002 Barry In Progress
003 Calvin New