I have external data that I'd like to make into a pie chart with Highchart. I want to dump the data into a .csv file, but what is the format?
This documentation only shows how to format .csv files for bar graphs: http://highcharts.com/documentation/how-to-use#preprocessi开发者_开发技巧ng
What if I want to make a pie chart?
Actually, there is no correct csv format for highcharts. Highcharts only accepts data in one of these three formats. The goal of the data-preprocessing is to transform the data into a supported javascript array format.
Quoting the reference:
data : Array An array of data points for the series. The points can be given in three ways:
A list of numerical values. In this case, the numberical values will be interpreted and y values, and x values will be automatically calculated, either starting at 0 and incrementing by 1, or from pointStart and pointInterval given in the plotOptions. If the axis is has categories, these will be used. Example:
data: [0, 5, 3, 5]
A list of arrays with two values. In this case, the first value is the x value and the second is the y value. If the first value is a string, it is applied as the name of the point, and the x value is incremented following the above rules. Example:
data: [[5, 2], [6, 3], [8, 2]]
A list of object with named values. In this case the objects are point configuration objects as seen under options.point. Example:
data: [{ name: 'Point 1', color: '#00FF00', y: 0 }, { name: 'Point 2', color: '#FF00FF', y: 5 }]
Defaults to "".
Found the answer on Highcharts' forum:
http://highslide.com/forum/viewtopic.php?f=9&t=8614&hilit=pie+chart+.csv
Make sure you don't have an extra new line at the end of your .csv file.
精彩评论