Google Charts Data Format
1. Annotation Chart: - Annotation charts are interactive time series line charts that support annotations.
You can display one or more lines on your chart. In this chart we have to pass set of data.
- First Column Should Be Date or Datetime.
- Then the next column should be (number, string, string) in three set of data
- Each data line is then described by a set of one to three additional columns
Example: -
data.addColumn('date', 'Date'); à First Column
data.addColumn('number', 'Kepler scion');
data.addColumn('string', 'Kepler title'); à Set Of Data (1st)
data.addColumn('string', 'Kepler text');
data.addColumn('number', 'Gliese scion'); data.addColumn('string', 'Gliese title'); à Set of Data (2nd) data.addColumn('string', 'Gliese text');
2. Area Chart: - An area chart that is rendered within the browser using SVG (Scalar Vector Graphic) or VML (Vector Mark-up Language). Displays tips when hovering over points.
Data Should be in this format: - Minimum 2 columns required.
v Column 0 should be either NUMBER, STRING OR DATE TIME.
v Column 1 should be NUMBER.
v Column n should be NUMBER.
Example: -
['Year', 'Sales', 'Expenses'],
['2013', 1000, 400],
['2014’, 1170, 460],
['2015', 660, 1120],
['2016', 1030, 540]
3. Bar Chart: - Google bar charts are rendered in the browser using SVG or VML, whichever is appropriate for the user's browser. Like all Google charts, bar charts display tooltips when the user hovers over the data.
Data Should be in format: - Minimum 2 columns required.
v Column 0 should be either NUMBER, STRING OR DATE TIME.
v Column 1 should be NUMBER.
v Column n should be NUMBER.
For Vertical Version of this chart select COLUMN CHART.
4. Bubble Chart: - A bubble chart is used to visualize a data set with two to four dimensions. The first two dimensions are visualized as coordinates, the third as color and the fourth as size.
Data Should be in format: - Minimum 3 column required.
v Column 0 should be STRING.
v Column 1 should be NUMBER.
v Column 2 should be NUMBER.
v Column 3 is OPTIONAL & should be either STRING OR NUMBER.
v Column 4 is OPTIONAL & should be NUMBER.
5. Calendar Chart: - A calendar chart is a visualization used to show activity over the course of a long span of time, such as months or years. They're best used when you want to illustrate how some quantity varies depending on the day of the week, or how it trends over time.
Data Should be in format: - Minimum 2 column required.
v Column 0 should be DATE or DATETIME, TIMEOFDAY
v Column 1 should be NUMBER.
6. Candlestick Chart: - A candlestick chart is used to show an opening and closing value overlaid on top of a total variance. Candlestick charts are often used to show stock value behavior.
Data Should be in format: - Minimum 5 column required.
v Column 0 should be DATE or STRING.
v Column 1 should be NUMBER. This Column is visible in Legend (i.e.: - right side text), (while the labels of the other columns are ignored).
v Column 2 should be NUMBER.
v Column 3 should be NUMBER.
v Column 4 should be NUMBER.
7. Column Chart: - A column chart is a vertical bar chart rendered in the browser using SVG or VML, whichever is appropriate for the user's browser. Like all Google charts, column charts display tooltips when the user hovers over the data. For a horizontal version of this chart.
Data Should be in format: - Minimum 2 column required.
v Column 0 should be either NUMBER, STRING OR DATE TIME.
v Column 1 should be NUMBER.
v Column n should be NUMBER.
8. Combo Chart: - A chart that lets you render each series as a different marker type from the following list: line, area, bars, candlesticks, and stepped area.
Data Should be in format: - Minimum 2 column required.
v Column 0 should be either NUMBER, STRING OR DATE TIME.
v Column 1 should be NUMBER.
v Column n should be NUMBER.
9. Diff Chart: - A diff chart is a chart designed to highlight the differences between two charts with comparable data.
You create a diff chart by calling the
computeDiff method with two datasets to generate a third dataset representing the diff, and then drawing that.
10. Donut Chart: - A donut chart is a pie chart with a hole in the center. You can create donut charts with the pieHole option:
Data Should be in format: - Minimum 2 column required.
v Column 0 should be STRING.
v Column 1 should be NUMBER.
v Column n should be Optional.
11. Gantt Charts: - A Gantt chart is a type of chart that illustrates the breakdown of a project into its component tasks. Google Gantt charts illustrate the start, end, and duration of tasks within a project, as well as any dependencies a task may have.
Note: Gantt Charts will not work in old versions of Internet Explorer. (IE8 and earlier versions don't support SVG, which Gantt Charts require.)
Data Should be in format: - Minimum 7 column required.
v Column 0 should be STRING.
v Column 1 should be STRING.
v Column 2 should be DATE. (START)
v Column 3 should be DATE. (END)
v Column 4 should be NUMBER.
v Column 5 should be INTERGER.
v Column 6 should be STRING.
12. Gauge Chart: - A gauge looks like a dial, rendered within the browser using svg and vml.
v One String and one Number is enough.
No more info is there in google chart doc.
13. Geo Chart: - A geochart is a map of a country, a continent, or a region with areas identified in one of three ways:
v The region mode colours whole regions, such as countries, provinces, or states.
v The markers mode uses circles to designate regions that are scaled according to a value that you specify.
v The text mode labels the regions with identifiers (e.g., "Russia" or "Asia").
Minimum 2 columns required. (column 1 should be country name & column 2 should be either number or string
14. Histogram Chart: - A histogram is a chart that groups numeric data into bins, displaying the bins as segmented columns. They're used to depict the distribution of a dataset: how often values fall into ranges.
"Minimum 1 column required. (column should be string, number or date)
15. Interval Chart: - Google Charts can display intervals around a series. They might be used to portray confidence intervals, minimum and maximum values around a value, percentile sampling, or anything else that requires a varying margin around a series.
Data Should be in format: - Minimum 2 column required.
v Column 0 should be STRING.
v Column 1 should be NUMBER.
16. Line Chart: - A line chart that is rendered within the browser using SVG or VML. Displays tooltips when hovering over points.
Data Should be in format: - Minimum 2 column required.
v Column 0 should be STRING, NUMBER OR DATE.
v Column 1 should be NUMBER.
17. Map Chart: - The Google Map Chart displays a map using the Google Map API. Data values are displayed as markers on the map. Data values can be coordinates (latitude-longitude pairs) or addresses. The map will be scaled so that it includes all the identified points.
18. Org Chart: - Org charts are diagrams of a hierarchy of nodes, commonly used to portray superior/subordinate relationships in an organization. A family tree is a type of org chart.
Minimum 2 Columns required. both should be string.
19. Pie Chart: - A pie chart that is rendered within the browser using SVG or VML. Displays tooltips when hovering over slices.
Minimum 2 columns required. (Column 1 should be string & column 2 should be number.
20. Sankey Chart: - A Sankey diagram is a visualization used to depict a flow from one set of values to another. The things being connected are called nodes and the connections are called links. Sankey’s are best used when you want to show a many-to-many mapping between two domains (e.g., universities and majors) or multiple paths through a set of stages (for instance, Google Analytics uses Sankey’s to show how traffic flows from pages to other pages on your web site)
Data Should be in format: - Minimum 3 column required.
v Column 0 should be STRING.
v Column 1 should be STRING.
v Column 2 should be INTERGER.
21. Scatter Chart: - Scatter charts plot points on a graph. When the user hovers over the points, tooltips are displayed with more information.
Data Should be in format: - Minimum 2 column required.
v Column 0 should be STRING, NUMBER OR DATE.
v Column 1 should be STRING, NUMBER OR DATE.
22. scatter-chart: - Scatter charts plot points on a graph. When the user hovers over the points, tooltips are displayed with more information.
Minimum
2 columns required. (Column 1 should be either number, string or date
& column 2 should be either number, string or date.
23. stepped-area-chart: - A stepped area chart that is rendered within the browser using SVG or VML. Displays tips when hovering over steps.
note = "Minimum
2 columns required. (Column 1 should be either number, string or date
& column 2 should be either number, string or date.)";
24. Table Chart: - A table that can be sorted and paged. Table cells can be formatted using format strings, or by directly inserting HTML as cell values. Numeric values are right-aligned; boolean values are displayed as check marks. Users can select single rows either with the keyboard or the mouse. Users can sort rows by clicking on column headers. The header row remains fixed as the user scrolls. The table fires a number of events corresponding to user interaction.
Data Should be in format: - Minimum 1 column required.
v Column 0 should be STRING, NUMBER OR NUMBER.
25. Timeline Chart: - A timeline is
a chart that depicts how a set of resources are used over time. If
you're managing a software project and want to illustrate who is doing
what and when, or if you're organizing a conference and need to schedule
meeting rooms, a timeline is often a reasonable visualization choice.
One popular type of timeline is the Gantt chart.
Data Should be in format: - Minimum 5 column required.
v Column 0 should be STRING.
v Column 1 should be STRING.
v Column 2 should be STRING.
v Column 3 should be DATE or NUMBER.
v Column 4 should be DATE or NUMBER.
26. Tree-Map chart: - A visual representation of a data tree, where each node can have zero or more children, and one parent (except for the root, which has no parents). Each node is displayed as a rectangle, sized and coloured according to values that you assign.
Data Should be in format: - Minimum 5 column required.
v Column 0 should be STRING.
v Column 1 should be STRING.
v Column 2 should be STRING.
v Column 3 should be DATE or NUMBER.
v Column 4 should be DATE or NUMBER.
27. Trendlines: - A trendline
is a line superimposed on a chart revealing the overall direction of
the data. Google Charts can automatically generate trendlines for
Scatter Charts, Bar Charts, Column Charts, and Line Charts.
Data Should be in format: - Minimum 2 column required.
v Column 0 should be STRING, NUMBER OR DATE.
v Column 1 should be STRING, NUMBER OR DATE.
28. Waterfall Chart: - With the right set of options, candlestick charts can be made to resemble simple waterfall charts.
29. Wordtree Chart: - A word tree depicts multiple parallel sequences of words. It could be used to show which words most often follow or precede a target word (e.g., "Cats are...") or to show a hierarchy of terms (e.g., a decision tree).
Google
word trees are able to process large amounts of text quickly. Modern
systems should be able to handle novel-sized amounts of text without
significant delay.
