Can I chart with a varchar column?
I have a pet table that has a column for type (e.g. PetType). It will contain either "Dog" or "Cat". I'm trying to create a pie chart of this column. I only see one of the values in the top left area of the chart (e.g. "Cat") and only a "-" in the middle of the chart.
Thanks