Hi,
I'm looking for a chart to display non numerical data points. Something simple like months on the y axis, categories on the x axis, and simple points to represent them.
DataSet might look like, (Feb, Cat1), (Jan, Cat3).
I was hoping to use the scatter plot. However, the axis didn't like non numeric data.
Thank you for your suggestions in advance.
Can you provide some more information about your scenario? I am not sure I have ever seen a scenario where string data is useful on a scatter chart axis.
Also, if we supported DateTime values on the Y axis would that satisfy your requirement? That would let you create a line chart, or as Max suggested a Point chart that accepts DateTime values on the Y and string data (like categories) on the X axis.
Devin
Thanks for the replies.
Max,
I was thinking about converting the "categories" to numerics, then formating the axis labels, but wasn't sure how to do it. The closest example I could find was the date converter/formatter.
I'll try a Point Chart and investigate this idea further.
Devin,
Maybe a small similar data set would help give you some context.
(Jan,HR,Fail),(Jan,Accounting,Fail),(Jan,Sales,Fail)
(Feb,HR,Fail),(Feb, Accounting,Pass),(Feb,Sales,Fail)
(Mar,HR,Fail),(Mar, Accounting,Pass),(Mar,Sales,Pass)
etc...
I built a prototype as a POC. Essentially a grid, with y axis (HR, Accounting,Sales), x axis (Jan, Feb, Mar, etc...) and each datagrid cell a color(green for pass, red for fail).
Of course it's not as pretty, functional, or elegant as Infragistics.
Gabe