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?
This site is in read only mode. Please continue to browse, but replying, likes,
and other actions are disabled for now.
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