Because it isn’t always immediately evident what type of chart would provide the best visualization of data, Chartio is able to intelligently consider the layout of the dataset along with decisions made by other Chartio users about similar datasets to automatically choose a chart type that will fit your data.
To take advantage of our auto recommend feature, collect your data from your various sources using our Dataset query tool, combine and manipulate the results in our pipeline as normal, then click the Auto button next to the chart types in the preview in the right panel. You can click this button at any time, regardless of whether you have already manually chosen a chart type or not.
This feature works because Chartio has gathered metadata about thousands of charts that have already been created by our users. Analysis of the characteristics of these data sets, such as the number of rows, number of columns, and the data type of each column, allows us to recommend an appropriate presentation of your results.
Chartio uses machine learning to recommend chart types that best display your information in it’s current form. Thus, as is the case with most applications of machine learning, the behavior of this feature will likely evolve over time as it becomes exposed to more training data and as the algorithm is tweaked.
Chart types that are grayed out are not appropriate for your data as it is currently organized. If you would like to use a chart type that isn’t available, click on your preferred chart type to see more information about the format that you would need to have to use this chart type. You can then continue to aggregate or manipulate (for example, reorder, hide, pivot or combine your columns) to match your desired chart type.