Show drill-downs

Allows you to select charts that users will be navigated to when they click on a series. See more about drilldowns in Wikipedia.

Data label and callout format

Type text that you want to see in the data label or callout. The following tags will be replaced by actual values:
For example, data point formatted with "{category}: {series} {value}%" may end up looking like this: 2013: Firefox 19%.

When displaying numeric values, you can choose number format using Javascript Intl.NumberFormat specification: "{value;NumberFormat:{locale:'<locale>', options:{<options>}}}". For full list of options, check out Intl.NumberFormat documentation at Mozilla developer network.

Examples: Callout format for XY charts is fixed and cannot be changed.

More about number formats in charte.ca blog.

Crisp edges

There are two options available for this setting:
Use "Crisp edges" setting only if you are 100% sure that: otherwise lines may look odd. Also, "crisp edges" setting may not work well on high-DPI laptops with image scaling turned on (it is common for high-DPI Windows laptops to have image scaling option set to 125% or 150%).

For more information about chart scaling/resizing, see charte.ca blog.

Axis value format

In most cases, having just "{value}" here will be enough. Sometimes you may want to decorate the value with some additional symbols, for example "{value}%".

When displaying numeric values, you can choose number format using Javascript Intl.NumberFormat specification: "{value;NumberFormat:{locale:'<locale>', options:{<options>}}}". For full list of options, check out Intl.NumberFormat documentation at Mozilla developer network.

Examples:

More about number formats in charte.ca blog.

Data labels inside/outside bars

This switch is disabled when data labels are disabled in the "Data labels" section of the chart editor.

Data label visibility

Turns on/off static data label visibility. Please note that for some types of charts like bar and pie, labels are not displayed if they do not fit into the correspondent bar or pie sector. For bubble/motion charts, data labels are displayed regardless of the bubble size.

Import flat CSV/TSV data (Pie, Bar, Line)

This is a sample walkthrough that shows how to import comma- or tab-separated values into data grid. It uses the same technique as Excel pivot table does. Each step reperesents a screen of the import wizard.

Step 1: Raw data (tab-separated-values with headers)

Paste your comma- or tab-separated text data into the "raw data" field on step 1 of the import wizard.

Crime category Crime type State State abbr Year Crime rate Population
Violent CrimeAssaultAlaskaAK196045.10.2M
Violent CrimeAssaultAlaskaAK196151.70.2M
Violent CrimeAssaultAlabamaAL1960138.13.3M
Violent CrimeAssaultAlabamaAL1961128.93.3M
Property CrimeBurglaryAlaskaAK1960332.10.2M
Property CrimeBurglaryAlaskaAK1961380.80.2M
Property CrimeBurglaryAlabamaAL1960355.93.3M
Property CrimeBurglaryAlabamaAL1961339.33.3M


Step 2: Raw data columns to use

"State" column values (Alaska, Alabama) will be used for series names. "Year" column values (1960,1961) will be used for category names. "Crime rate" column values will be used for series/category intersection cells.



Step 3: Filter

In this particular example, we are interested only in Burglary numbers.



Step 4 : aggregate function

No need to specify aggregate function for this example: the "Burglary" filter guarantees there is only one value for each Series/Category pair.

Step 5: Sort order

Sort series and categories in ascending order.



Result

After we complete the wizard, the aggregated data is in the data grid, ready for use by the chart engine.

T Category Series
Series
LabelAlabamaAlaska
Value1960355.9332.1
Value1961339.3380.9


For more information about import techniques, see charte.ca blog.

Import flat CSV/TSV data (Scatter regular)

This is a sample walkthrough that shows how to import comma- or tab-separated values into data grid. It shows how raw data samples are converted into data grid columns. Each step reperesents a screen of the import wizard.

Step 1: Raw data (tab-separated-values with headers)

Paste your comma- or tab-separated text data into the "raw data" field on step 1 of the import wizard.

Crime category Crime type State State abbr Year Crime rate Population
Violent CrimeAssaultAlaskaAK196045.10.2M
Violent CrimeAssaultAlaskaAK196151.70.2M
Violent CrimeAssaultAlabamaAL1960138.13.3M
Violent CrimeAssaultAlabamaAL1961128.93.3M
Property CrimeBurglaryAlaskaAK1960332.10.2M
Property CrimeBurglaryAlaskaAK1961380.80.2M
Property CrimeBurglaryAlabamaAL1960355.93.3M
Property CrimeBurglaryAlabamaAL1961339.33.3M


Step 2: Raw data columns to use

"Population" column values will be used as X axis coordinates. "Crime rate" column values will be used as Y axis coordinates. A few other columns will be used as optional variables, displayed in callouts.



Step 3: Filter

In this particular example, we are interested in all samples. Leave all dropdowns empty.

Step 4: X sort order

Sort samples in ascending order.



Result

After we complete the wizard, the aggregated data is in the data grid, ready for use by the chart engine.

T Variable Sample
Sample
Sample
Sample
Sample
Sample
Sample
Sample
XPopulation0.2M0.2M0.2M0.2M3.3M3.3M3.3M3.3M
YCrime rate45.151.7332.1380.8138.1128.9355.9339.3
OptionalStateAlaskaAlaskaAlaskaAlaskaAlabamaAlabamaAlabamaAlabama
OptionalYear19601961196019611960196119601961
OptionalCrime typeAssaultAssaultBurglaryBurglaryAssaultAssaultBurglaryBurglary


For more information about import techniques, see charte.ca blog.

Import flat CSV/TSV data (Scatter grouped)

This is a sample walkthrough that shows how to import comma- or tab-separated values into data grid. It shows how raw data samples are converted into data grid columns. Each step reperesents a screen of the import wizard.

Step 1: Raw data (tab-separated-values with headers)

Paste your comma- or tab-separated text data into the "raw data" field on step 1 of the import wizard.

Crime category Crime type State State abbr Year Crime rate Population
Violent CrimeAssaultAlaskaAK196045.10.2M
Violent CrimeAssaultAlaskaAK196151.70.2M
Violent CrimeAssaultAlabamaAL1960138.13.3M
Violent CrimeAssaultAlabamaAL1961128.93.3M
Property CrimeBurglaryAlaskaAK1960332.10.2M
Property CrimeBurglaryAlaskaAK1961380.80.2M
Property CrimeBurglaryAlabamaAL1960355.93.3M
Property CrimeBurglaryAlabamaAL1961339.33.3M


Step 2: Raw data columns to use

"Population" column values will be used as X axis coordinates. "Crime rate" column values will be used as Y axis coordinates. "Crime type" column values will be used for grouping. A few other columns will be used as optional variables, displayed in callouts.



Step 3: Filter

In this particular example, we are interested in all samples. Leave all dropdowns empty.

Step 4: X sort order

Sort samples in ascending order.



Result

After we complete the wizard, the aggregated data is in the data grid, ready for use by the chart engine. Please note the group coloring.

T Variable Sample
Sample
Sample
Sample
Sample
Sample
Sample
Sample
XPopulation0.2M0.2M0.2M0.2M3.3M3.3M3.3M3.3M
YCrime rate45.151.7332.1380.8138.1128.9355.9339.3
GroupCrime typeAssaultAssaultBurglaryBurglaryAssaultAssaultBurglaryBurglary
OptionalStateAlaskaAlaskaAlaskaAlaskaAlabamaAlabamaAlabamaAlabama
OptionalYear19601961196019611960196119601961


For more information about import techniques, see charte.ca blog.

Import flat CSV/TSV data (Bubble regular)

This is a sample walkthrough that shows how to import comma- or tab-separated values into data grid. It shows how raw data samples are converted into data grid columns. Each step reperesents a screen of the import wizard.

Step 1: Raw data (tab-separated-values with headers)

Paste your comma- or tab-separated text data into the "raw data" field on step 1 of the import wizard.

Symbol Company Cap(billions) P/E Yield Sector
KOCoca-Cola186.72253.22Consumer
PEPPepsi154.5530.322.8Consumer
GMGM48.924.044.82Consumer
FFord49.975.524.84Consumer
JPMJP Morgan Chase239.3311.22.9Financial
CCiti136.449.881.36Financial
MSMorgan Stanley59.6914.292.57Financial
GSGoldman Sachs67.5415.71.57Financial
MSFTMicrosoft453.9227.612.48Technology
AAPLApple573.7912.492.13Technology
SAPSAP107.126.021.5Technology
ORCLOracle170.2319.911.45Technology


Step 2: Raw data columns to use

"P/E" column values will be used as X axis coordinates. "Yield" column values will be used as Y axis coordinates. "Cap(billions)" column values will be used as Z coordinates (circle size). "Symbol" column values will be used as bubble labels. A few other columns will be used as optional variables, displayed in callouts.



Step 3: Filter

In this particular example, we are interested in all samples. Leave all dropdowns empty.

Step 4: X sort order

Sort samples in ascending order.



Result

After we complete the wizard, the aggregated data is in the data grid, ready for use by the chart engine.

T Variable Sample
Sample
Sample
Sample
Sample
Sample
Sample
Sample
Sample
Sample
Sample
Sample
LabelSymbolGMFCJPMAAPLMSGSORCLKOSAPMSFTPEP
xP/E4.045.529.8811.212.4914.2915.719.912526.0227.6130.32
yYield4.824.841.362.92.132.571.571.453.221.52.482.8
zCap(billions)48.9249.97136.44239.33573.7959.6967.54170.23186.72107.1453.92154.55
OptionalCompanyGMFordCitiJPMorgan ChaseAppleMorgan StanleyGoldman SachsOracleCoca-ColaSAPMicrosoftPepsi
OptionalSectorConsumerConsumerFinancialFinancialTechnologyFinancialFinancialTechnologyConsumerTechnologyTechnologyConsumer


For more information about import techniques, see charte.ca blog.

Import flat CSV/TSV data (Comparative histogram)

This is a sample walkthrough that shows how to import comma- or tab-separated values into data grid. It uses the same technique as Excel pivot table does. Each step reperesents a screen of the import wizard.

Step 1: Raw data (tab-separated-values with headers)

Paste your comma- or tab-separated text data into the "raw data" field on step 1 of the import wizard.

Year Sex Age Value
2015Male0 - 410177601
2015Male5 - 910459132
2015Male10 - 1410520388
2015Male15 - 1910797867
2015Male20 - 2411667854
2015Male25 - 2911409399
2015Male30 - 3410889739
2015Male35 - 3910173424
2015Male40 - 4410030153
2015Male45 - 4910334929
2015Male50 - 5410963847
2015Male55 - 5910597567
2015Male60 - 649117180
2015Male65 - 697596190
2015Male70 - 745296158
2015Male75 - 793610906
2015Male80 - 842412665
2015Male85 - 891442244
2015Male90 - 94588978
2015Male95 - 99127988
2015Male100 +15088
2015Female0 - 49729680
2015Female5 - 910028044
2015Female10 - 1410101942
2015Female15 - 1910311036
2015Female20 - 2411071459
2015Female25 - 2911052155
2015Female30 - 3410785909
2015Female35 - 3910201161
2015Female40 - 4410185045
2015Female45 - 4910518915
2015Female50 - 5411370470
2015Female55 - 5911210375
2015Female60 - 649952697
2015Female65 - 698471278
2015Female70 - 746186891
2015Female75 - 794512927
2015Female80 - 843386676
2015Female85 - 892422101
2015Female90 - 941261957
2015Female95 - 99366919
2015Female100 +61886
2010Male0 - 410319427
2010Male5 - 910389638
2010Male10 - 1410579862
2010Male15 - 1911303666
2010Male20 - 2411014176
2010Male25 - 2910635591
2010Male30 - 349996500
2010Male35 - 3910042022
2010Male40 - 4410393977
2010Male45 - 4911209085
2010Male50 - 5410933274
2010Male55 - 599523648
2010Male60 - 648077500
2010Male65 - 695852547
2010Male70 - 744243972
2010Male75 - 793182388
2010Male80 - 842294374
2010Male85 - 891273867
2010Male90 - 94424387
2010Male95 - 9982263
2010Male100 +9162
2010Female0 - 49881935
2010Female5 - 99959019
2010Female10 - 1410097332
2010Female15 - 1910736677
2010Female20 - 2410571823
2010Female25 - 2910466258
2010Female30 - 349965599
2010Female35 - 3910137620
2010Female40 - 4410496987
2010Female45 - 4911499506
2010Female50 - 5411364851
2010Female55 - 5910141157
2010Female60 - 648740424
2010Female65 - 696582716
2010Female70 - 745034194
2010Female75 - 794135407
2010Female80 - 843448953
2010Female85 - 892346592
2010Female90 - 941023979
2010Female95 - 99288981
2010Female100 +44202
2005Male0 - 410381346
2005Male5 - 99993397
2005Male10 - 1410681835
2005Male15 - 1910790223
2005Male20 - 2410856936
2005Male25 - 2910268169
2005Male30 - 3410153091
2005Male35 - 3910563375
2005Male40 - 4411376664
2005Male45 - 4911106575
2005Male50 - 549788780
2005Male55 - 598425070
2005Male60 - 646201648
2005Male65 - 694721791
2005Male70 - 743807605
2005Male75 - 793117774
2005Male80 - 842161671
2005Male85 - 891092012
2005Male90 - 94404657
2005Male95 - 9993114
2005Male100 +14013
2005Female0 - 49922378
2005Female5 - 99545396
2005Female10 - 1410175908
2005Female15 - 1910248766
2005Female20 - 2410180924
2005Female25 - 299797533
2005Female30 - 349924119
2005Female35 - 3910438579
2005Female40 - 4411483846
2005Female45 - 4911377948
2005Female50 - 5410208962
2005Female55 - 598928608
2005Female60 - 646800215
2005Female65 - 695409653
2005Female70 - 744700764
2005Female75 - 794294039
2005Female80 - 843480878
2005Female85 - 892118491
2005Female90 - 941010281
2005Female95 - 99307279
2005Female100 +56091
2000Male0 - 49810733
2000Male5 - 910523277
2000Male10 - 1410520197
2000Male15 - 1910391004
2000Male20 - 249687814
2000Male25 - 299798760
2000Male30 - 3410321769
2000Male35 - 3911318696
2000Male40 - 4411129102
2000Male45 - 499889506
2000Male50 - 548607724
2000Male55 - 596508729
2000Male60 - 645136627
2000Male65 - 694400362
2000Male70 - 743902912
2000Male75 - 793044456
2000Male80 - 841834897
2000Male85 - 89876501
2000Male90 - 94282325
2000Male95 - 9958115
2000Male100 +10057
2000Female0 - 49365065
2000Female5 - 910026228
2000Female10 - 1410007875
2000Female15 - 199828886
2000Female20 - 249276187
2000Female25 - 299582576
2000Female30 - 3410188619
2000Female35 - 3911387968
2000Female40 - 4411312761
2000Female45 - 4910202898
2000Female50 - 548977824
2000Female55 - 596960508
2000Female60 - 645668820
2000Female65 - 695133183
2000Female70 - 744954529
2000Female75 - 794371357
2000Female80 - 843110470
2000Female85 - 891913317
2000Female90 - 94830206
2000Female95 - 99228669
2000Female100 +40397


Step 2: Raw data columns to use

"State" column values (Alaska, Alabama) will be used for series names. "Year" column values (1960,1961) will be used for category names. "Crime rate" column values will be used for series/category intersection cells.



Step 3: Filter

In this particular example, we are interested in all samples. Leave all dropdowns empty.

Step 4 : aggregate function

Comparative histogram import does not support aggregation.

Step 5: Sort order

Sort series and categories in ascending order.



Result

After we complete the wizard, the aggregated data is in the data grid, ready for use by the chart engine.

T Category Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Label (series)FemaleFemaleFemaleFemaleFemaleFemaleFemaleFemaleFemaleFemaleFemaleFemaleFemaleFemaleFemaleFemaleFemaleFemaleFemaleFemaleFemaleMaleMaleMaleMaleMaleMaleMaleMaleMaleMaleMaleMaleMaleMaleMaleMaleMaleMaleMaleMaleMale
Label (sub-series)0 - 45 - 910 - 1415 - 1920 - 2425 - 2930 - 3435 - 3940 - 4445 - 4950 - 5455 - 5960 - 6465 - 6970 - 7475 - 7980 - 8485 - 8990 - 9495 - 99100 +0 - 45 - 910 - 1415 - 1920 - 2425 - 2930 - 3435 - 3940 - 4445 - 4950 - 5455 - 5960 - 6465 - 6970 - 7475 - 7980 - 8485 - 8990 - 9495 - 99100 +
Value200093650651002622810007875982888692761879582576101886191138796811312761102028988977824696050856688205133183495452943713573110470191331783020622866940397981073310523277105201971039100496878149798760103217691131869611129102988950686077246508729513662744003623902912304445618348978765012823255811510057
Value200599223789545396101759081024876610180924979753399241191043857911483846113779481020896289286086800215540965347007644294039348087821184911010281307279560911038134699933971068183510790223108569361026816910153091105633751137666411106575978878084250706201648472179138076053117774216167110920124046579311414013
Value20109881935995901910097332107366771057182310466258996559910137620104969871149950611364851101411578740424658271650341944135407344895323465921023979288981442021031942710389638105798621130366611014176106355919996500100420221039397711209085109332749523648807750058525474243972318238822943741273867424387822639162
Value20159729680100280441010194210311036110714591105215510785909102011611018504510518915113704701121037599526978471278618689145129273386676242210112619573669196188610177601104591321052038810797867116678541140939910889739101734241003015310334929109638471059756791171807596190529615836109062412665144224458897812798815088


For more information about import techniques, see charte.ca blog.

Import flat CSV/TSV data (Bubble grouped)

This is a sample walkthrough that shows how to import comma- or tab-separated values into data grid. It shows how raw data samples are converted into data grid columns. Each step reperesents a screen of the import wizard.

Step 1: Raw data (tab-separated-values with headers)

Paste your comma- or tab-separated text data into the "raw data" field on step 1 of the import wizard.

Symbol Company Cap(billions) P/E Yield Sector
KOCoca-Cola186.72253.22Consumer
PEPPepsi154.5530.322.8Consumer
GMGM48.924.044.82Consumer
FFord49.975.524.84Consumer
JPMJP Morgan Chase239.3311.22.9Financial
CCiti136.449.881.36Financial
MSMorgan Stanley59.6914.292.57Financial
GSGoldman Sachs67.5415.71.57Financial
MSFTMicrosoft453.9227.612.48Technology
AAPLApple573.7912.492.13Technology
SAPSAP107.126.021.5Technology
ORCLOracle170.2319.911.45Technology


Step 2: Raw data columns to use

"P/E" column values will be used as X axis coordinates. "Yield" column values will be used as Y axis coordinates. "Cap(billions)" column values will be used as Z coordinates (circle size). "Symbol" column values will be used as bubble labels. "Sector" column values will be used for grouping. Other columns may be used as optional variables, displayed in callouts.



Step 3: Filter

In this particular example, we are interested in all samples. Leave all dropdowns empty.

Step 4: X sort order

Sort samples in ascending order.



Result

After we complete the wizard, the aggregated data is in the data grid, ready for use by the chart engine. Please note the group coloring.

T Variable Sample
Sample
Sample
Sample
Sample
Sample
Sample
Sample
Sample
Sample
Sample
Sample
LabelSymbolGMFCJPMAAPLMSGSORCLKOSAPMSFTPEP
xP/E4.045.529.8811.212.4914.2915.719.912526.0227.6130.32
yYield4.824.841.362.92.132.571.571.453.221.52.482.8
zCap(billions)48.9249.97136.44239.33573.7959.6967.54170.23186.72107.1453.92154.55
GroupSectorConsumerConsumerFinancialFinancialTechnologyFinancialFinancialTechnologyConsumerTechnologyTechnologyConsumer
OptionalCompanyGMFordCitiJPMorgan ChaseAppleMorgan StanleyGoldman SachsOracleCoca-ColaSAPMicrosoftPepsi


For more information about import techniques, see charte.ca blog.

Import flat CSV/TSV data (Motion)

This is a sample walkthrough that shows how to import comma- or tab-separated values into data grid. It shows how raw data samples are converted into data grid columns. Each step reperesents a screen of the import wizard.

Step 1: Raw data (tab-separated-values with headers)

Paste your comma- or tab-separated text data into the "raw data" field on step 1 of the import wizard.

Year Region Region abbreviation Outflow Inflow Population Timezone
1911AtlanticATL7.83.1937,955Atlantic/Newfoundland
1911QuebecQC5.81.52,005,776Eastern
1911OntarioON13.33.92,527,292Eastern
1911ManitobaMB17.934.4461,394Central
1911SaskatchewanSK5.857.9492,432Central
1911AlbertaAB6.154.0374,295Mountain
1911British ColumbiaBC3.949.6392,480Pacific
1921AtlanticATL9.54.11,000,328Atlantic/Newfoundland
1921QuebecQC6.42.12,361,199Eastern
1921OntarioON13.24.72,933,622Eastern
1921ManitobaMB17.124.7610,118Central
1921SaskatchewanSK8.637.0757,510Central
1921AlbertaAB8.138.0588,454Mountain
1921British ColumbiaBC6.140.3524,582Pacific
1931AtlanticATL11.14.51,009,103Atlantic/Newfoundland
1931QuebecQC5.73.02,874,662Eastern
1931OntarioON11.35.53,431,683Eastern
1931ManitobaMB19.419.3700,139Central
1931SaskatchewanSK11.926.6921,785Central
1931AlbertaAB10.829.4731,605Mountain
1931British ColumbiaBC5.937.6694,263Pacific
1941AtlanticATL11.04.91,130,410Atlantic/Newfoundland
1941QuebecQC5.03.53,331,882Eastern
1941OntarioON9.27.13,787,655Eastern
1941ManitobaMB21.416.4729,744Central
1941SaskatchewanSK20.419.0895,992Central
1941AlbertaAB13.522.9796,169Mountain
1941British ColumbiaBC5.938.5817,861Pacific
1951AtlanticATL15.16.31,618,126Atlantic/Newfoundland
1951QuebecQC5.64.24,055,681Eastern
1951OntarioON8.410.94,597,542Eastern
1951ManitobaMB27.016.0776,541Central
1951SaskatchewanSK32.816.3831,728Central
1951AlbertaAB18.624.4939,501Mountain
1951British ColumbiaBC9.343.51,165,210Pacific
1961AtlanticATL18.68.11,897,425Atlantic/Newfoundland
1961QuebecQC5.54.65,259,211Eastern
1961OntarioON7.811.86,236,092Eastern
1961ManitobaMB28.015.8921,686Central
1961SaskatchewanSK35.514.3925,181Central
1961AlbertaAB18.424.51,331,944Mountain
1961British ColumbiaBC9.836.91,629,082Pacific
1971AtlanticATL22.99.72,083,210Atlantic/Newfoundland
1971QuebecQC6.24.66,137,305Eastern
1971OntarioON7.513.17,849,027Eastern
1971ManitobaMB30.616.1998,876Central
1971SaskatchewanSK40.013.0932,038Central
1971AlbertaAB20.425.51,665,717Mountain
1971British ColumbiaBC9.837.42,240,470Pacific
1981AtlanticATL24.811.62,260,162Atlantic/Newfoundland
1981QuebecQC7.84.16,547,207Eastern
1981OntarioON10.113.38,812,286Eastern
1981ManitobaMB33.816.21,035,545Central
1981SaskatchewanSK41.814.5975,759Central
1981AlbertaAB20.835.32,291,104Mountain
1981British ColumbiaBC11.639.72,826,558Pacific
1991AtlanticATL26.212.92,370,549Atlantic/Newfoundland
1991QuebecQC8.04.17,067,396Eastern
1991OntarioON9.313.310,431,316Eastern
1991ManitobaMB32.215.71,109,604Central
1991SaskatchewanSK41.113.41,002,713Central
1991AlbertaAB21.431.72,592,306Mountain
1991British ColumbiaBC11.836.73,373,787Pacific
2001AtlanticATL27.313.62,341,021Atlantic/Newfoundland
2001QuebecQC7.93.87,396,415Eastern
2001OntarioON9.311.911,897,370Eastern
2001ManitobaMB31.314.91,151,450Central
2001SaskatchewanSK40.513.61,000,239Central
2001AlbertaAB19.632.43,058,084Mountain
2001British ColumbiaBC12.033.64,076,881Pacific
2011AtlanticATL28.915.62,369,074Atlantic/Newfoundland
2011QuebecQC7.54.08,007,656Eastern
2011OntarioON9.510.813,263,544Eastern
2011ManitobaMB30.514.51,233,728Central
2011SaskatchewanSK38.915.61,066,349Central
2011AlbertaAB19.133.03,790,191Mountain
2011British ColumbiaBC13.231.04,499,139Pacific


Step 2: Raw data columns to use

"P/E" column values will be used as X axis coordinates. "Yield" column values will be used as Y axis coordinates. "Cap(billions)" column values will be used as Z coordinates (circle size). "Symbol" column values will be used as bubble labels. "Sector" column values will be used for grouping. Other columns may be used as optional variables, displayed in callouts.



Step 3: Filter

In this particular example, we are interested in all samples. Leave all dropdowns empty.

Step 4 : aggregate function

No aggregation supported for motion chart import.

Step 5: sort order

Leave categories and series unordered



Result

After we complete the wizard, the aggregated data is in the data grid, ready for use by the chart engine.

T Category Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Series
Label (series)ABABABABABATLATLATLATLATLBCBCBCBCBCMBMBMBMBMBONONONONONQCQCQCQCQCSKSKSKSKSK
Label (x,y,z,optionals)OutflowInflowPopulationRegionTimezoneOutflowInflowPopulationRegionTimezoneOutflowInflowPopulationRegionTimezoneOutflowInflowPopulationRegionTimezoneOutflowInflowPopulationRegionTimezoneOutflowInflowPopulationRegionTimezoneOutflowInflowPopulationRegionTimezone
Value19116.154.0374,295AlbertaMountain7.83.1937,955AtlanticAtlantic/Newfoundland3.949.6392,480British ColumbiaPacific17.934.4461,394ManitobaCentral13.33.92,527,292OntarioEastern5.81.52,005,776QuebecEastern5.857.9492,432SaskatchewanCentral
Value19218.138.0588,454AlbertaMountain9.54.11,000,328AtlanticAtlantic/Newfoundland6.140.3524,582British ColumbiaPacific17.124.7610,118ManitobaCentral13.24.72,933,622OntarioEastern6.42.12,361,199QuebecEastern8.637.0757,510SaskatchewanCentral
Value193110.829.4731,605AlbertaMountain11.14.51,009,103AtlanticAtlantic/Newfoundland5.937.6694,263British ColumbiaPacific19.419.3700,139ManitobaCentral11.35.53,431,683OntarioEastern5.73.02,874,662QuebecEastern11.926.6921,785SaskatchewanCentral
Value194113.522.9796,169AlbertaMountain11.04.91,130,410AtlanticAtlantic/Newfoundland5.938.5817,861British ColumbiaPacific21.416.4729,744ManitobaCentral9.27.13,787,655OntarioEastern5.03.53,331,882QuebecEastern20.419.0895,992SaskatchewanCentral
Value195118.624.4939,501AlbertaMountain15.16.31,618,126AtlanticAtlantic/Newfoundland9.343.51,165,210British ColumbiaPacific27.016.0776,541ManitobaCentral8.410.94,597,542OntarioEastern5.64.24,055,681QuebecEastern32.816.3831,728SaskatchewanCentral
Value196118.424.51,331,944AlbertaMountain18.68.11,897,425AtlanticAtlantic/Newfoundland9.836.91,629,082British ColumbiaPacific28.015.8921,686ManitobaCentral7.811.86,236,092OntarioEastern5.54.65,259,211QuebecEastern35.514.3925,181SaskatchewanCentral
Value197120.425.51,665,717AlbertaMountain22.99.72,083,210AtlanticAtlantic/Newfoundland9.837.42,240,470British ColumbiaPacific30.616.1998,876ManitobaCentral7.513.17,849,027OntarioEastern6.24.66,137,305QuebecEastern40.013.0932,038SaskatchewanCentral
Value198120.835.32,291,104AlbertaMountain24.811.62,260,162AtlanticAtlantic/Newfoundland11.639.72,826,558British ColumbiaPacific33.816.21,035,545ManitobaCentral10.113.38,812,286OntarioEastern7.84.16,547,207QuebecEastern41.814.5975,759SaskatchewanCentral
Value199121.431.72,592,306AlbertaMountain26.212.92,370,549AtlanticAtlantic/Newfoundland11.836.73,373,787British ColumbiaPacific32.215.71,109,604ManitobaCentral9.313.310,431,316OntarioEastern8.04.17,067,396QuebecEastern41.113.41,002,713SaskatchewanCentral
Value200119.632.43,058,084AlbertaMountain27.313.62,341,021AtlanticAtlantic/Newfoundland12.033.64,076,881British ColumbiaPacific31.314.91,151,450ManitobaCentral9.311.911,897,370OntarioEastern7.93.87,396,415QuebecEastern40.513.61,000,239SaskatchewanCentral
Value201119.133.03,790,191AlbertaMountain28.915.62,369,074AtlanticAtlantic/Newfoundland13.231.04,499,139British ColumbiaPacific30.514.51,233,728ManitobaCentral9.510.813,263,544OntarioEastern7.54.08,007,656QuebecEastern38.915.61,066,349SaskatchewanCentral


For more information about import techniques, see charte.ca blog.

Import flat CSV/TSV data (XY Heatmap, single category)

This is a sample walkthrough that shows how to import comma- or tab-separated values into data grid. It shows how raw data samples are converted into data grid columns. Each step reperesents a screen of the import wizard.

Step 1: Raw data (tab-separated-values with headers)

Paste your comma- or tab-separated text data into the "raw data" field on step 1 of the import wizard.

year weekday time
2015Monday09:00-10:00
2015Monday18:00-19:00
2015Monday21:00-22:00
2015Monday23:00-24:00
.........


Step 2: Raw data columns to use

"weekday" column values will be used as X axis coordinates. "time" column values will be used as Y axis coordinates. For this particular example, select NONE for value column - we will be using COUNT aggregate function.



Step 3: Filter

In this particular example, we are interested in all samples. Leave all dropdowns empty.

Step 4 : aggregate function

In this particular example, select COUNT, as we are interested in the number of incidents that occurred any year, at specified weekday, at specified time.



Step 5: sort order

Set Y sort order to "asc" - we want it to be ordered alphabetically. For X axis, set "none" - it will guarantee that weekdays will keep the order they appear in the source CSV data.



Result

After we complete the wizard, the aggregated data is in the data grid, ready for use by the chart engine.

T y value value value ...
xMondayTuesdayWednesday...
value00:00-01:00567489543...
value01:00-02:00365320377...
value02:00-03:00268301245...
..................


For more information about import techniques, see charte.ca blog.

Import flat CSV/TSV data (XY Heatmap, multiple categories)

This is a sample walkthrough that shows how to import comma- or tab-separated values into data grid. It shows how raw data samples are converted into data grid columns. Each step reperesents a screen of the import wizard.

Step 1: Raw data (tab-separated-values with headers)

Paste your comma- or tab-separated text data into the "raw data" field on step 1 of the import wizard.

year weekday time
2015Monday09:00-10:00
2015Monday18:00-19:00
2015Monday21:00-22:00
2015Monday23:00-24:00
.........


Step 2: Raw data columns to use

"year" column values will be used as categories (radio buttons). "weekday" column values will be used as X axis coordinates. "time" column values will be used as Y axis coordinates. For this particular example, select NONE for value column - we will be using COUNT aggregate function.



Step 3: Filter

In this particular example, we are interested in all samples. Leave all dropdowns empty.

Step 4 : aggregate function

In this particular example, select COUNT, as we are interested in the number of incidents that occurred durung specified year, at specified weekday, at specified time.



Step 5: sort order

Set Y and category sort order to "asc" - we want them to be ordered alphabetically. For X axis, set "none" - it will guarantee that weekdays will keep the order they appear in the source CSV data.



Result

After we complete the wizard, the aggregated data is in the data grid, ready for use by the chart engine.

T Category Point Point Point ...
xMondayMondayMonday...
y00:00-01:0001:00-02:0002:00-03:00...
value2003855747...
value2004935038...
value...............


For more information about import techniques, see charte.ca blog.

Background SVG content

You can provide your own SVG background content.

It is recommended to:

Please note that your background SVG content must be valid, otherwise your chart will not render properly.

Check out examples below, you can copy-and-paste them to the "Background SVG content" field and see what it looks like on your chart.

Sample image (size 626x626):

<svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" width="100%" height="100%" version="1.1" preserveAspectRatio="none" viewBox="0 0 626 626">
  <image xlink:href="https://image.freepik.com/free-vector/blue-abstract-background-with-mandalas_1159-956.jpg" height="626px" width="626px"/>
</svg> 


Sample SVG drawing (size 640x480):

<svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" width="100%" height="100%" version="1.1" preserveAspectRatio="none" viewBox="0 0 640 480">
  <rect x="0" y="0" width="640" height="480" rx="0" ry="0" fill="#80F080" opacity="1"/>
  <path d="M0,480 L640,480 L640,0 Z" fill="#F08080" opacity="1"/>
  <text x="120" y="130" fill="#20A020" font-family="Tahoma" font-size="38px">Green area</text>
  <text x="430" y="300" fill="#A02020" font-family="Tahoma" font-size="38px">Red area</text>
</svg>


Sample SVG animation (size 735x600, source: https://upload.wikimedia.org/wikipedia/commons/0/06/Retro-flower-icon-5petals.svg):

<svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" width="100%" height="100%" viewBox="0 0 735 600">
<defs>
  <g id="f1">
    <path transform="translate(206,212) scale(0.242,-0.242)" fill="#11a533" d="M201.479,585.379 C206.197,602.986,208.586,621.136,208.586,639.365 C208.586,754.564,115.199,847.951,0,847.951 C-115.199,847.951,-208.586,754.564,-208.586,639.365 C-208.586,621.136,-206.197,602.986,-201.479,585.379 L-95.9868,191.676 C-95.1387,188.51,-94.709,185.247,-94.709,181.97 C-94.709,161.26,-111.499,144.47,-132.209,144.47 C-139.458,144.47,-146.553,146.572,-152.633,150.52 L-494.468,372.51 C-528.287,394.472,-567.748,406.161,-608.072,406.161 C-723.271,406.161,-816.659,312.773,-816.659,197.574 C-816.659,86.6179,-729.793,-4.91895,-618.989,-10.7258 L-211.956,-32.0579 C-192.036,-33.1016,-176.419,-49.5586,-176.419,-69.5063 C-176.419,-80.8201,-181.527,-91.5293,-190.319,-98.6494 L-507.077,-355.155 C-555.983,-394.759,-584.396,-454.326,-584.396,-517.257 C-584.396,-632.456,-491.008,-725.844,-375.809,-725.844 C-289.452,-725.844,-212.024,-672.629,-181.077,-592.008 L-35.009,-211.489 C-29.4453,-196.995,-15.5251,-187.427,0,-187.427 C15.5251,-187.427,29.4453,-196.995,35.009,-211.489 L181.077,-592.008 C212.024,-672.629,289.452,-725.844,375.809,-725.844 C491.008,-725.844,584.396,-632.456,584.396,-517.257 C584.396,-454.326,555.983,-394.759,507.077,-355.155 L190.319,-98.6494 C181.527,-91.5293,176.419,-80.8201,176.419,-69.5063 C176.419,-49.5586,192.036,-33.1016,211.956,-32.0579 L618.989,-10.7258 C729.793,-4.91895,816.659,86.6179,816.659,197.574 C816.659,312.773,723.271,406.161,608.072,406.161 C567.748,406.161,528.287,394.472,494.468,372.51 L152.633,150.52 C146.553,146.572,139.458,144.47,132.209,144.47 C111.499,144.47,94.709,161.26,94.709,181.97 C94.709,185.247,95.1387,188.51,95.9868,191.676 L201.479,585.379Z M60,0 C60,-33.137,33.137,-60,0,-60 C-33.137,-60,-60,-33.137,-60,0 C-60,33.137,-33.137,60,0,60 C33.137,60,60,33.137,60,0Z"/>
  </g>
  <g id="f2">
    <path transform="translate(572,167) scale(0.185,-0.185)" fill="#1155f5" d="M-835.178,190.487 C-835.178,354.392,-682.808,463.661,-518.279,463.661 C-446.082,463.661,-365.733,443.286,-283.066,389.606 C-293.48,428.482,-300.233,470.17,-300.233,511.531 C-300.233,713.924,-155.608,865.543,0,865.543 C155.608,865.543,300.233,713.924,300.233,511.531 C300.233,470.17,293.48,428.482,283.066,389.606 C365.733,443.286,446.082,463.661,518.279,463.661 C682.808,463.661,835.178,354.392,835.178,190.487 C835.178,39.2025,702.063,-136.016,458.01,-148.816 C608.923,-271.038,619.471,-412.877,619.471,-463.72 C619.471,-624.177,513.072,-748.968,351.509,-748.968 C238.951,-748.968,77.623,-683.769,0,-481.58 C-77.623,-683.769,-238.951,-748.968,-351.509,-748.968 C-513.072,-748.968,-619.471,-624.177,-619.471,-463.72 C-619.471,-412.877,-608.923,-271.038,-458.01,-148.816 C-702.063,-136.016,-835.178,39.2025,-835.178,190.487Z M-241.442,0 C-241.442,-133.345,-133.345,-241.442,0,-241.442 C133.345,-241.442,241.442,-133.345,241.442,0 C241.442,133.345,133.345,241.442,0,241.442 C-133.345,241.442,-241.442,133.345,-241.442,0Z"/>
  </g>
  <g id="f3">
    <path transform="translate(468,456) scale(0.158,-0.158)" fill="#f5a533" d="M-966.219,0 C-966.219,155.608,-814.6,300.233,-612.207,300.233 C-570.846,300.233,-529.158,293.48,-490.283,283.066 C-563.875,360.688,-620.055,458.892,-620.055,573.794 C-620.055,742.173,-509.134,870.76,-352.786,870.76 C-207.156,870.76,-54.7822,756.352,0,566.13 C54.7822,756.352,207.156,870.76,352.786,870.76 C509.134,870.76,620.055,742.173,620.055,573.794 C620.055,458.892,563.875,360.688,490.283,283.066 C529.158,293.48,570.846,300.233,612.207,300.233 C814.6,300.233,966.219,155.608,966.219,0 C966.219,-155.608,814.6,-300.233,612.207,-300.233 C570.846,-300.233,529.158,-293.48,490.283,-283.066 C563.875,-360.688,620.055,-458.892,620.055,-573.794 C620.055,-742.173,509.134,-870.76,352.786,-870.76 C207.156,-870.76,54.7812,-756.352,0,-566.13 C-54.7822,-756.352,-207.156,-870.76,-352.786,-870.76 C-509.134,-870.76,-620.055,-742.173,-620.055,-573.794 C-620.055,-458.892,-563.875,-360.688,-490.283,-283.066 C-529.158,-293.48,-570.846,-300.233,-612.207,-300.233 C-814.6,-300.233,-966.219,-155.608,-966.219,0Z M-269.526,0 C-269.526,-148.855,-148.855,-269.526,0,-269.526 C148.855,-269.526,269.526,-148.855,269.526,0 C269.526,148.855,148.855,269.526,0,269.526 C-148.855,269.526,-269.526,148.855,-269.526,0Z"/>
  </g>
</defs>
<use xlink:href="#f1" transform="translate(0 0) scale(1 1)">
  <animateTransform attributeName="transform" type="translate" values="0,0;100,100;0,0" keyTimes="0.0;0.5;1.0" dur="10s" repeatCount="indefinite"/> <animateTransform attributeName="transform" type="scale" values="1,1;0.5,0.5;1,1" keyTimes="0.0;0.5;1.0" dur="10s" repeatCount="indefinite" additive="sum"/>
</use>
<use xlink:href="#f2" transform="translate(0 0) scale(1 1)">
  <animateTransform attributeName="transform" type="translate" values="0,0;250,80;0,0" keyTimes="0.0;0.5;1.0" dur="10s" repeatCount="indefinite" /> <animateTransform attributeName="transform" type="scale" values="1,1;0.5,0.5;1,1" keyTimes="0.0;0.5;1.0" dur="10s" repeatCount="indefinite" additive="sum"/>
</use>
<use xlink:href="#f3" transform="translate(0 0) scale(1 1)">
  <animateTransform attributeName="transform" type="translate" values="0,0;230,225;0,0" keyTimes="0.0;0.5;1.0" dur="10s" repeatCount="indefinite" /> <animateTransform attributeName="transform" type="scale" values="1,1;0.5,0.5;1,1" keyTimes="0.0;0.5;1.0" dur="10s" repeatCount="indefinite" additive="sum"/>
</use>
</svg>


For full SVG reference, see: Documentation by Mozilla.

Note: Internet Explorer does not support SVG background feature due to IE bug. Edge supports SVG backgrounds without limitations.

For more information about SVG backgrounds, see charte.ca blog.

Browser requirements

In order to edit or view charte.ca charts, you browser must support Javascript ES6 features. If you end up here, chances are youyr browser does not support ES6. Consider using a moder browser.

Sharing

charte.ca editor allows you to share charts with other users for editing.

To share a chart with another user, click "Share with another user" button on the "Sharing" panel. In the popup, you will be presented with an invitation link that you have to pass to the target user. After the user clicks on this link, this chart will appear in his/her "Charts" / "Shared with me" chart list.

To stop sharing a chart with a user, or to cancel your invitation, click "delete" button right from the user name/link in the shared user list.

If you do not want to see the chart that was shared with you in your "Shared with me" list, click on that chart's "delete" icon on the "Shared with me" screen.

If someone shared a chart with you, you can edit the chart and save your edits, but you cannot:

Read more about sharing in charte.ca blog.