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